Overview

Dataset statistics

Number of variables39
Number of observations119468
Missing cells352641
Missing cells (%)7.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory35.5 MiB
Average record size in memory312.0 B

Variable types

Numeric7
Categorical26
DateTime6

Alerts

Coste MOE has constant value " 0.00 €" Constant
Centro de coste has constant value " " Constant
Descripción has a high cardinality: 7192 distinct values High cardinality
DNI has a high cardinality: 16700 distinct values High cardinality
Desc. Equipo has a high cardinality: 12589 distinct values High cardinality
Generador OT has a high cardinality: 69 distinct values High cardinality
Observaciones Aviso has a high cardinality: 82 distinct values High cardinality
Descripción de los Trabajos Realizados has a high cardinality: 7141 distinct values High cardinality
Observaciones has a high cardinality: 1034 distinct values High cardinality
Centro de trabajo has a high cardinality: 378 distinct values High cardinality
Árbol departamental has a high cardinality: 1014 distinct values High cardinality
Coste Material has a high cardinality: 192 distinct values High cardinality
Tipo de Componente has a high cardinality: 139 distinct values High cardinality
Núm. Serie has a high cardinality: 1463 distinct values High cardinality
Operario PDA has a high cardinality: 76 distinct values High cardinality
O.T. is highly correlated with Núm. AvisoHigh correlation
Núm. Aviso is highly correlated with O.T. and 1 other fieldsHigh correlation
Prioridad is highly correlated with Tipo and 5 other fieldsHigh correlation
tiempo_parada_horas is highly correlated with Coste MOE and 1 other fieldsHigh correlation
Coste MOI is highly correlated with Coste MOE and 1 other fieldsHigh correlation
Generador OT is highly correlated with Tipo and 9 other fieldsHigh correlation
Coste MOE is highly correlated with Prioridad and 14 other fieldsHigh correlation
Estado is highly correlated with Operario PDA and 1 other fieldsHigh correlation
Solicitante is highly correlated with Generador OT and 2 other fieldsHigh correlation
Servicio is highly correlated with Tipo and 5 other fieldsHigh correlation
Operario PDA is highly correlated with Tipo and 9 other fieldsHigh correlation
Observaciones Aviso is highly correlated with Núm. Aviso and 6 other fieldsHigh correlation
Centro de coste is highly correlated with Prioridad and 14 other fieldsHigh correlation
Tipo Intervención is highly correlated with Tipo and 9 other fieldsHigh correlation
Generador Aviso is highly correlated with Generador OT and 4 other fieldsHigh correlation
Matrícula is highly correlated with Generador OT and 1 other fieldsHigh correlation
Tipo is highly correlated with Generador OT and 5 other fieldsHigh correlation
Tipo de Incidencia is highly correlated with Tipo and 3 other fieldsHigh correlation
tiempo_parada_minutos is highly correlated with Generador Aviso and 2 other fieldsHigh correlation
tiempo_estimado_horas is highly correlated with Operario PDAHigh correlation
tiempo_estimado_minutos is highly correlated with Tipo Intervención and 3 other fieldsHigh correlation
tiempo_mo_minutos is highly correlated with Estado and 1 other fieldsHigh correlation
Núm. Aviso has 118578 (99.3%) missing values Missing
Datetime_aviso has 118578 (99.3%) missing values Missing
Datetime_inicio has 4188 (3.5%) missing values Missing
Datetime_fin has 65019 (54.4%) missing values Missing
Datetime_realización has 46278 (38.7%) missing values Missing
tiempo_parada_minutos is highly skewed (γ1 = 106.3054263) Skewed
tiempo_parada_minutos has 119453 (> 99.9%) zeros Zeros
tiempo_estimado_horas has 99986 (83.7%) zeros Zeros
tiempo_estimado_minutos has 38368 (32.1%) zeros Zeros
tiempo_mo_horas has 105592 (88.4%) zeros Zeros
tiempo_mo_minutos has 69510 (58.2%) zeros Zeros

Reproduction

Analysis started2022-09-08 14:08:46.144613
Analysis finished2022-09-08 14:11:46.324453
Duration3 minutes and 0.18 seconds
Software versionpandas-profiling v3.3.0
Download configurationconfig.json

Variables

O.T.
Real number (ℝ≥0)

HIGH CORRELATION

Distinct48967
Distinct (%)41.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean203135.5406
Minimum68544
Maximum230223
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size933.5 KiB

Quantile statistics

Minimum68544
5-th percentile179791
Q1191729
median204771
Q3215939
95-th percentile226351
Maximum230223
Range161679
Interquartile range (IQR)24210

Descriptive statistics

Standard deviation16071.47782
Coefficient of variation (CV)0.07911701604
Kurtosis1.874809237
Mean203135.5406
Median Absolute Deviation (MAD)11384
Skewness-0.7220734322
Sum2.426819676 × 1010
Variance258292399.4
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
226249366
 
0.3%
220724332
 
0.3%
204744332
 
0.3%
187154332
 
0.3%
210310328
 
0.3%
204890326
 
0.3%
204818306
 
0.3%
203655300
 
0.3%
194388288
 
0.2%
210267282
 
0.2%
Other values (48957)116276
97.3%
ValueCountFrequency (%)
685441
 
< 0.1%
692751
 
< 0.1%
905631
 
< 0.1%
959061
 
< 0.1%
1018471
 
< 0.1%
1037661
 
< 0.1%
1049281
 
< 0.1%
1054302
 
< 0.1%
10573834
< 0.1%
1057792
 
< 0.1%
ValueCountFrequency (%)
2302231
< 0.1%
2302221
< 0.1%
2302211
< 0.1%
2302201
< 0.1%
2302191
< 0.1%
2302181
< 0.1%
2302171
< 0.1%
2302161
< 0.1%
2302151
< 0.1%
2302141
< 0.1%

Núm. Aviso
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct888
Distinct (%)99.8%
Missing118578
Missing (%)99.3%
Infinite0
Infinite (%)0.0%
Mean2929.619101
Minimum1904
Maximum3400
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size933.5 KiB

Quantile statistics

Minimum1904
5-th percentile2517.45
Q12702.25
median2933.5
Q33161.75
95-th percentile3345.55
Maximum3400
Range1496
Interquartile range (IQR)459.5

Descriptive statistics

Standard deviation273.4977989
Coefficient of variation (CV)0.09335609491
Kurtosis-0.6314032097
Mean2929.619101
Median Absolute Deviation (MAD)230
Skewness-0.1712028438
Sum2607361
Variance74801.04598
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
25652
 
< 0.1%
29472
 
< 0.1%
27481
 
< 0.1%
27391
 
< 0.1%
27401
 
< 0.1%
27431
 
< 0.1%
27451
 
< 0.1%
27441
 
< 0.1%
27461
 
< 0.1%
27501
 
< 0.1%
Other values (878)878
 
0.7%
(Missing)118578
99.3%
ValueCountFrequency (%)
19041
< 0.1%
19101
< 0.1%
19751
< 0.1%
20741
< 0.1%
22201
< 0.1%
23841
< 0.1%
24741
< 0.1%
24781
< 0.1%
24791
< 0.1%
24801
< 0.1%
ValueCountFrequency (%)
34001
< 0.1%
33991
< 0.1%
33971
< 0.1%
33961
< 0.1%
33941
< 0.1%
33931
< 0.1%
33921
< 0.1%
33911
< 0.1%
33901
< 0.1%
33891
< 0.1%

Tipo
Categorical

HIGH CORRELATION

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
Preventivo
105341 
Correctivo
 
8800
Conductivo
 
5327

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters1194680
Distinct characters12
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowPreventivo
2nd rowPreventivo
3rd rowPreventivo
4th rowPreventivo
5th rowPreventivo

Common Values

ValueCountFrequency (%)
Preventivo105341
88.2%
Correctivo8800
 
7.4%
Conductivo5327
 
4.5%

Length

Histogram of lengths of the category

Category Frequency Plot

ValueCountFrequency (%)
preventivo105341
88.2%
correctivo8800
 
7.4%
conductivo5327
 
4.5%

Most occurring characters

ValueCountFrequency (%)
v224809
18.8%
e219482
18.4%
o133595
11.2%
r122941
10.3%
t119468
10.0%
i119468
10.0%
n110668
9.3%
P105341
8.8%
C14127
 
1.2%
c14127
 
1.2%
Other values (2)10654
 
0.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter1075212
90.0%
Uppercase Letter119468
 
10.0%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
v224809
20.9%
e219482
20.4%
o133595
12.4%
r122941
11.4%
t119468
11.1%
i119468
11.1%
n110668
10.3%
c14127
 
1.3%
d5327
 
0.5%
u5327
 
0.5%
Uppercase Letter
ValueCountFrequency (%)
P105341
88.2%
C14127
 
11.8%

Most occurring scripts

ValueCountFrequency (%)
Latin1194680
100.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
v224809
18.8%
e219482
18.4%
o133595
11.2%
r122941
10.3%
t119468
10.0%
i119468
10.0%
n110668
9.3%
P105341
8.8%
C14127
 
1.2%
c14127
 
1.2%
Other values (2)10654
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII1194680
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
v224809
18.8%
e219482
18.4%
o133595
11.2%
r122941
10.3%
t119468
10.0%
i119468
10.0%
n110668
9.3%
P105341
8.8%
C14127
 
1.2%
c14127
 
1.2%
Other values (2)10654
 
0.9%

Estado
Categorical

HIGH CORRELATION

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
Realizado
73190 
Abierto
46278 

Length

Max length9
Median length9
Mean length8.225265343
Min length7

Characters and Unicode

Total characters982656
Distinct characters12
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowRealizado
2nd rowRealizado
3rd rowRealizado
4th rowRealizado
5th rowRealizado

Common Values

ValueCountFrequency (%)
Realizado73190
61.3%
Abierto46278
38.7%

Length

Histogram of lengths of the category

Category Frequency Plot

ValueCountFrequency (%)
realizado73190
61.3%
abierto46278
38.7%

Most occurring characters

ValueCountFrequency (%)
a146380
14.9%
e119468
12.2%
i119468
12.2%
o119468
12.2%
R73190
7.4%
l73190
7.4%
z73190
7.4%
d73190
7.4%
A46278
 
4.7%
b46278
 
4.7%
Other values (2)92556
9.4%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter863188
87.8%
Uppercase Letter119468
 
12.2%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a146380
17.0%
e119468
13.8%
i119468
13.8%
o119468
13.8%
l73190
8.5%
z73190
8.5%
d73190
8.5%
b46278
 
5.4%
r46278
 
5.4%
t46278
 
5.4%
Uppercase Letter
ValueCountFrequency (%)
R73190
61.3%
A46278
38.7%

Most occurring scripts

ValueCountFrequency (%)
Latin982656
100.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
a146380
14.9%
e119468
12.2%
i119468
12.2%
o119468
12.2%
R73190
7.4%
l73190
7.4%
z73190
7.4%
d73190
7.4%
A46278
 
4.7%
b46278
 
4.7%
Other values (2)92556
9.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII982656
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
a146380
14.9%
e119468
12.2%
i119468
12.2%
o119468
12.2%
R73190
7.4%
l73190
7.4%
z73190
7.4%
d73190
7.4%
A46278
 
4.7%
b46278
 
4.7%
Other values (2)92556
9.4%

Descripción
Categorical

HIGH CARDINALITY

Distinct7192
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
Bomba - Gama Mensual
15927 
Control Legionela Despositos - Gama Diaria
9530 
Cuadro Eléctrico - Gama Mensual
8341 
Fancoil - Gama Trimestral
8289 
Fancoil - Gama Semestral
 
3876
Other values (7187)
73505 

Length

Max length499
Median length484
Mean length29.95133425
Min length4

Characters and Unicode

Total characters3578226
Distinct characters118
Distinct categories16 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique6687 ?
Unique (%)5.6%

Sample

1st rowCuadro Eléctrico - Gama Mensual
2nd rowCuadro Eléctrico - Gama Mensual
3rd rowVaso Expansión - Gama Mensual
4th rowCuadro Eléctrico - Gama Mensual
5th rowCaldera Gas - Gama Trimestral

Common Values

ValueCountFrequency (%)
Bomba - Gama Mensual15927
 
13.3%
Control Legionela Despositos - Gama Diaria9530
 
8.0%
Cuadro Eléctrico - Gama Mensual8341
 
7.0%
Fancoil - Gama Trimestral8289
 
6.9%
Fancoil - Gama Semestral3876
 
3.2%
UTA - Gama Mensual3832
 
3.2%
Vaso Expansión - Gama Mensual3580
 
3.0%
Unidad Interior Climatización3431
 
2.9%
Extintor - Gama Trimestral3196
 
2.7%
Bomba - Gama Semestral2783
 
2.3%
Other values (7182)56683
47.4%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
110693
18.5%
gama100835
16.9%
mensual53250
 
8.9%
bomba20506
 
3.4%
trimestral19398
 
3.2%
control13274
 
2.2%
de12300
 
2.1%
fancoil12253
 
2.1%
diaria12033
 
2.0%
legionela11337
 
1.9%
Other values (7763)231731
38.8%

Most occurring characters

ValueCountFrequency (%)
a489966
13.7%
478089
 
13.4%
e196580
 
5.5%
r183672
 
5.1%
o181999
 
5.1%
i174585
 
4.9%
m173909
 
4.9%
l171117
 
4.8%
n160139
 
4.5%
s158843
 
4.4%
Other values (108)1209327
33.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter2362856
66.0%
Uppercase Letter596196
 
16.7%
Space Separator478092
 
13.4%
Dash Punctuation109508
 
3.1%
Decimal Number20045
 
0.6%
Other Punctuation7948
 
0.2%
Control1667
 
< 0.1%
Other Letter661
 
< 0.1%
Open Punctuation463
 
< 0.1%
Close Punctuation457
 
< 0.1%
Other values (6)333
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a489966
20.7%
e196580
8.3%
r183672
 
7.8%
o181999
 
7.7%
i174585
 
7.4%
m173909
 
7.4%
l171117
 
7.2%
n160139
 
6.8%
s158843
 
6.7%
t113075
 
4.8%
Other values (26)358971
15.2%
Uppercase Letter
ValueCountFrequency (%)
G110020
18.5%
M58083
9.7%
A56015
9.4%
C51896
8.7%
E46668
 
7.8%
T39603
 
6.6%
D35227
 
5.9%
S29226
 
4.9%
B23958
 
4.0%
L19127
 
3.2%
Other values (24)126373
21.2%
Other Punctuation
ValueCountFrequency (%)
.3030
38.1%
/2676
33.7%
,1323
16.6%
:837
 
10.5%
?28
 
0.4%
"27
 
0.3%
&6
 
0.1%
5
 
0.1%
;5
 
0.1%
¿3
 
< 0.1%
Other values (5)8
 
0.1%
Decimal Number
ValueCountFrequency (%)
13984
19.9%
33853
19.2%
23499
17.5%
02411
12.0%
51738
8.7%
41239
 
6.2%
61175
 
5.9%
8797
 
4.0%
7677
 
3.4%
9672
 
3.4%
Math Symbol
ValueCountFrequency (%)
>125
52.7%
<105
44.3%
+6
 
2.5%
×1
 
0.4%
Control
ValueCountFrequency (%)
846
50.7%
810
48.6%
11
 
0.7%
Space Separator
ValueCountFrequency (%)
478089
> 99.9%
 3
 
< 0.1%
Dash Punctuation
ValueCountFrequency (%)
-109500
> 99.9%
8
 
< 0.1%
Open Punctuation
ValueCountFrequency (%)
(377
81.4%
[86
 
18.6%
Close Punctuation
ValueCountFrequency (%)
)371
81.2%
]86
 
18.8%
Other Letter
ValueCountFrequency (%)
º350
53.0%
ª311
47.0%
Modifier Symbol
ValueCountFrequency (%)
´1
50.0%
`1
50.0%
Other Symbol
ValueCountFrequency (%)
°86
100.0%
Connector Punctuation
ValueCountFrequency (%)
_5
100.0%
Final Punctuation
ValueCountFrequency (%)
2
100.0%
Initial Punctuation
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin2959713
82.7%
Common618513
 
17.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
a489966
16.6%
e196580
 
6.6%
r183672
 
6.2%
o181999
 
6.1%
i174585
 
5.9%
m173909
 
5.9%
l171117
 
5.8%
n160139
 
5.4%
s158843
 
5.4%
t113075
 
3.8%
Other values (62)955828
32.3%
Common
ValueCountFrequency (%)
478089
77.3%
-109500
 
17.7%
13984
 
0.6%
33853
 
0.6%
23499
 
0.6%
.3030
 
0.5%
/2676
 
0.4%
02411
 
0.4%
51738
 
0.3%
,1323
 
0.2%
Other values (36)8410
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII3547238
99.1%
None30970
 
0.9%
Punctuation18
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
a489966
13.8%
478089
13.5%
e196580
 
5.5%
r183672
 
5.2%
o181999
 
5.1%
i174585
 
4.9%
m173909
 
4.9%
l171117
 
4.8%
n160139
 
4.5%
s158843
 
4.5%
Other values (76)1178339
33.2%
None
ValueCountFrequency (%)
ó13843
44.7%
é8705
28.1%
í2814
 
9.1%
á2297
 
7.4%
ñ658
 
2.1%
Ó613
 
2.0%
ú490
 
1.6%
Ñ361
 
1.2%
º350
 
1.1%
ª311
 
1.0%
Other values (17)528
 
1.7%
Punctuation
ValueCountFrequency (%)
8
44.4%
5
27.8%
2
 
11.1%
2
 
11.1%
1
 
5.6%

DNI
Categorical

HIGH CARDINALITY

Distinct16700
Distinct (%)14.0%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
EDF-TP29-EDF-MTOGN-001
 
900
EDF-V34-MTOGN-001
 
591
EDF-MM-C33-ED-MTTOGN
 
546
EDF-OS11-EDF-MTOGN-001
 
417
EDF-IDOM-ACU00-002
 
396
Other values (16695)
116618 

Length

Max length48
Median length42
Mean length24.06287876
Min length11

Characters and Unicode

Total characters2874744
Distinct characters46
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1945 ?
Unique (%)1.6%

Sample

1st rowEDF-V34-CE000-004
2nd rowEDF-V34-CE000-006
3rd rowSAT-R03-VPPE-VEXP0-004
4th rowEDF-OS11-P05-TERZ-CE000-023
5th rowSAT-R09-SANM-SANMAS-GCA70-004

Common Values

ValueCountFrequency (%)
EDF-TP29-EDF-MTOGN-001900
 
0.8%
EDF-V34-MTOGN-001591
 
0.5%
EDF-MM-C33-ED-MTTOGN546
 
0.5%
EDF-OS11-EDF-MTOGN-001417
 
0.3%
EDF-IDOM-ACU00-002396
 
0.3%
EDF-IDOM-ACU00-001396
 
0.3%
EDF-OMBU3-EDIF-GEN-MTOGN373
 
0.3%
EDF-UTO-PH9.11-MTOGN-001332
 
0.3%
EDF-TOR77-SUR-CUB-ACU00-002306
 
0.3%
EDF-TOR77-NORTE-CUB-ACU00-001306
 
0.3%
Other values (16690)114905
96.2%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
edf-tp29-edf-mtogn-001900
 
0.8%
edf-v34-mtogn-001591
 
0.5%
edf-mm-c33-ed-mttogn546
 
0.5%
edf-os11-edf-mtogn-001417
 
0.3%
edf-idom-acu00-002396
 
0.3%
edf-idom-acu00-001396
 
0.3%
edf-ombu3-edif-gen-mtogn373
 
0.3%
edf-uto-ph9.11-mtogn-001332
 
0.3%
edf-tor77-sur-cub-acu00-002306
 
0.3%
edf-tor77-norte-cub-acu00-001306
 
0.3%
Other values (16690)114905
96.2%

Most occurring characters

ValueCountFrequency (%)
-544379
18.9%
0479032
16.7%
E153816
 
5.4%
A145527
 
5.1%
M132020
 
4.6%
C119764
 
4.2%
F112586
 
3.9%
T108862
 
3.8%
1107194
 
3.7%
S100883
 
3.5%
Other values (36)870681
30.3%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter1489385
51.8%
Decimal Number835846
29.1%
Dash Punctuation544379
 
18.9%
Other Punctuation3733
 
0.1%
Lowercase Letter1237
 
< 0.1%
Connector Punctuation146
 
< 0.1%
Math Symbol18
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
E153816
10.3%
A145527
 
9.8%
M132020
 
8.9%
C119764
 
8.0%
F112586
 
7.6%
T108862
 
7.3%
S100883
 
6.8%
D99739
 
6.7%
R74383
 
5.0%
P70649
 
4.7%
Other values (16)371156
24.9%
Decimal Number
ValueCountFrequency (%)
0479032
57.3%
1107194
 
12.8%
358391
 
7.0%
252369
 
6.3%
727601
 
3.3%
426517
 
3.2%
624231
 
2.9%
523343
 
2.8%
919777
 
2.4%
817391
 
2.1%
Lowercase Letter
ValueCountFrequency (%)
y867
70.1%
n124
 
10.0%
i75
 
6.1%
t75
 
6.1%
d49
 
4.0%
u47
 
3.8%
Dash Punctuation
ValueCountFrequency (%)
-544379
100.0%
Other Punctuation
ValueCountFrequency (%)
.3733
100.0%
Connector Punctuation
ValueCountFrequency (%)
_146
100.0%
Math Symbol
ValueCountFrequency (%)
+18
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin1490622
51.9%
Common1384122
48.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
E153816
10.3%
A145527
 
9.8%
M132020
 
8.9%
C119764
 
8.0%
F112586
 
7.6%
T108862
 
7.3%
S100883
 
6.8%
D99739
 
6.7%
R74383
 
5.0%
P70649
 
4.7%
Other values (22)372393
25.0%
Common
ValueCountFrequency (%)
-544379
39.3%
0479032
34.6%
1107194
 
7.7%
358391
 
4.2%
252369
 
3.8%
727601
 
2.0%
426517
 
1.9%
624231
 
1.8%
523343
 
1.7%
919777
 
1.4%
Other values (4)21288
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII2874744
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
-544379
18.9%
0479032
16.7%
E153816
 
5.4%
A145527
 
5.1%
M132020
 
4.6%
C119764
 
4.2%
F112586
 
3.9%
T108862
 
3.8%
1107194
 
3.7%
S100883
 
3.5%
Other values (36)870681
30.3%

Desc. Equipo
Categorical

HIGH CARDINALITY

Distinct12589
Distinct (%)10.5%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
MANTENIMIENTO GENERAL
 
7725
PARÁMETROS CRÍTICOS
 
1432
BOMBA
 
1302
Deposito ACS
 
898
CALDERA 1
 
804
Other values (12584)
107307 

Length

Max length98
Median length78
Mean length24.80892791
Min length2

Characters and Unicode

Total characters2963873
Distinct characters96
Distinct categories11 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1369 ?
Unique (%)1.1%

Sample

1st rowCUADRO ELÉCTRICO - S2 - EXTRACCIÓN 1
2nd rowCUADRO ELÉCTRICO - S1 - GARAJE 1
3rd rowVASO DE EXPANSIÓN - SOLAR - VE04 (400L)
4th rowCUADRO ELÉCTRICO - CE-ASC.A1
5th rowCALDERA ACS - 65 kW

Common Values

ValueCountFrequency (%)
MANTENIMIENTO GENERAL7725
 
6.5%
PARÁMETROS CRÍTICOS1432
 
1.2%
BOMBA1302
 
1.1%
Deposito ACS898
 
0.8%
CALDERA 1804
 
0.7%
CALDERA 2715
 
0.6%
UNIDAD DE TRATAMIENTO DE AIRE651
 
0.5%
ACUMULADOR616
 
0.5%
ACUMULADOR ACS614
 
0.5%
MTTO GENERAL546
 
0.5%
Other values (12579)104165
87.2%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
56334
 
11.0%
bomba18900
 
3.7%
118183
 
3.5%
de16625
 
3.2%
216279
 
3.2%
planta12612
 
2.5%
general9983
 
1.9%
acs9520
 
1.9%
mantenimiento8321
 
1.6%
cuadro8246
 
1.6%
Other values (4546)338374
65.9%

Most occurring characters

ValueCountFrequency (%)
397207
 
13.4%
A290271
 
9.8%
O205834
 
6.9%
E190236
 
6.4%
R178074
 
6.0%
I157382
 
5.3%
N151750
 
5.1%
C142068
 
4.8%
T122817
 
4.1%
L107086
 
3.6%
Other values (86)1021148
34.5%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter2178089
73.5%
Space Separator397309
 
13.4%
Decimal Number163117
 
5.5%
Lowercase Letter98930
 
3.3%
Dash Punctuation67449
 
2.3%
Other Punctuation32215
 
1.1%
Open Punctuation9686
 
0.3%
Close Punctuation9668
 
0.3%
Other Letter7041
 
0.2%
Math Symbol345
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A290271
13.3%
O205834
 
9.5%
E190236
 
8.7%
R178074
 
8.2%
I157382
 
7.2%
N151750
 
7.0%
C142068
 
6.5%
T122817
 
5.6%
L107086
 
4.9%
S94814
 
4.4%
Other values (23)537757
24.7%
Lowercase Letter
ValueCountFrequency (%)
a12708
12.8%
o11196
11.3%
i9906
10.0%
r9116
9.2%
n8505
8.6%
e8478
8.6%
t7549
 
7.6%
d4339
 
4.4%
l4193
 
4.2%
c4058
 
4.1%
Other values (22)18882
19.1%
Decimal Number
ValueCountFrequency (%)
146728
28.6%
235686
21.9%
020308
12.4%
315860
 
9.7%
411531
 
7.1%
59829
 
6.0%
67216
 
4.4%
85790
 
3.5%
75644
 
3.5%
94525
 
2.8%
Other Punctuation
ValueCountFrequency (%)
.30043
93.3%
,861
 
2.7%
/741
 
2.3%
:500
 
1.6%
'46
 
0.1%
&20
 
0.1%
"4
 
< 0.1%
Math Symbol
ValueCountFrequency (%)
+186
53.9%
<82
23.8%
>61
 
17.7%
=16
 
4.6%
Space Separator
ValueCountFrequency (%)
397207
> 99.9%
 102
 
< 0.1%
Dash Punctuation
ValueCountFrequency (%)
-67414
99.9%
35
 
0.1%
Other Letter
ValueCountFrequency (%)
º6129
87.0%
ª912
 
13.0%
Control
ValueCountFrequency (%)
17
70.8%
7
29.2%
Open Punctuation
ValueCountFrequency (%)
(9686
100.0%
Close Punctuation
ValueCountFrequency (%)
)9668
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin2284060
77.1%
Common679813
 
22.9%

Most frequent character per script

Latin
ValueCountFrequency (%)
A290271
12.7%
O205834
 
9.0%
E190236
 
8.3%
R178074
 
7.8%
I157382
 
6.9%
N151750
 
6.6%
C142068
 
6.2%
T122817
 
5.4%
L107086
 
4.7%
S94814
 
4.2%
Other values (57)643728
28.2%
Common
ValueCountFrequency (%)
397207
58.4%
-67414
 
9.9%
146728
 
6.9%
235686
 
5.2%
.30043
 
4.4%
020308
 
3.0%
315860
 
2.3%
411531
 
1.7%
59829
 
1.4%
(9686
 
1.4%
Other values (19)35521
 
5.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII2925773
98.7%
None38065
 
1.3%
Punctuation35
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
397207
13.6%
A290271
 
9.9%
O205834
 
7.0%
E190236
 
6.5%
R178074
 
6.1%
I157382
 
5.4%
N151750
 
5.2%
C142068
 
4.9%
T122817
 
4.2%
L107086
 
3.7%
Other values (69)983048
33.6%
None
ValueCountFrequency (%)
Ó14365
37.7%
º6129
16.1%
É5386
 
14.1%
Í5101
 
13.4%
Á3242
 
8.5%
ó1014
 
2.7%
ª912
 
2.4%
Ñ910
 
2.4%
é475
 
1.2%
í238
 
0.6%
Other values (6)293
 
0.8%
Punctuation
ValueCountFrequency (%)
35
100.0%

Generador OT
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct69
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
104937 
LINO PUMAR
 
5255
JUAN VAZQUEZ
 
1938
JAVIER IGLESIAS VELASCO
 
719
ARTURO MORENO PEÑA
 
647
Other values (64)
 
5972

Length

Max length36
Median length1
Mean length2.693717146
Min length1

Characters and Unicode

Total characters321813
Distinct characters37
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique7 ?
Unique (%)< 0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
104937
87.8%
LINO PUMAR5255
 
4.4%
JUAN VAZQUEZ1938
 
1.6%
JAVIER IGLESIAS VELASCO719
 
0.6%
ARTURO MORENO PEÑA647
 
0.5%
SANTIAGO OLMOS586
 
0.5%
FRANCISCO BUENO PICAZO530
 
0.4%
ROBERTO LUNA PARRADO494
 
0.4%
FELIX GARCÍA376
 
0.3%
JAVIER CACELLER350
 
0.3%
Other values (59)3636
 
3.0%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
lino5255
 
15.0%
pumar5255
 
15.0%
juan2266
 
6.5%
vazquez1938
 
5.5%
javier1231
 
3.5%
santiago890
 
2.5%
arturo774
 
2.2%
iglesias719
 
2.0%
velasco719
 
2.0%
moreno647
 
1.8%
Other values (146)15413
43.9%

Most occurring characters

ValueCountFrequency (%)
125513
39.0%
A27330
 
8.5%
R17564
 
5.5%
O17476
 
5.4%
N15008
 
4.7%
E14795
 
4.6%
L13203
 
4.1%
I12943
 
4.0%
U12432
 
3.9%
M8508
 
2.6%
Other values (27)57041
17.7%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter196144
60.9%
Space Separator125513
39.0%
Decimal Number156
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A27330
13.9%
R17564
 
9.0%
O17476
 
8.9%
N15008
 
7.7%
E14795
 
7.5%
L13203
 
6.7%
I12943
 
6.6%
U12432
 
6.3%
M8508
 
4.3%
P7487
 
3.8%
Other values (20)49398
25.2%
Decimal Number
ValueCountFrequency (%)
449
31.4%
949
31.4%
248
30.8%
87
 
4.5%
12
 
1.3%
31
 
0.6%
Space Separator
ValueCountFrequency (%)
125513
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin196144
60.9%
Common125669
39.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
A27330
13.9%
R17564
 
9.0%
O17476
 
8.9%
N15008
 
7.7%
E14795
 
7.5%
L13203
 
6.7%
I12943
 
6.6%
U12432
 
6.3%
M8508
 
4.3%
P7487
 
3.8%
Other values (20)49398
25.2%
Common
ValueCountFrequency (%)
125513
99.9%
449
 
< 0.1%
949
 
< 0.1%
248
 
< 0.1%
87
 
< 0.1%
12
 
< 0.1%
31
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII318512
99.0%
None3301
 
1.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
125513
39.4%
A27330
 
8.6%
R17564
 
5.5%
O17476
 
5.5%
N15008
 
4.7%
E14795
 
4.6%
L13203
 
4.1%
I12943
 
4.1%
U12432
 
3.9%
M8508
 
2.7%
Other values (22)53740
16.9%
None
ValueCountFrequency (%)
Í1111
33.7%
Á812
24.6%
Ñ731
22.1%
Ó356
 
10.8%
É291
 
8.8%

Generador Aviso
Categorical

HIGH CORRELATION

Distinct14
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
118578 
JAVIER IGLESIAS VELASCO
 
516
GREGORIO VIEJO PÉREZ
 
113
SAREB
 
56
DIEGO HERNÁNDEZ GARCÍA
 
51
Other values (9)
 
154

Length

Max length36
Median length1
Mean length1.147462082
Min length1

Characters and Unicode

Total characters137085
Distinct characters34
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
118578
99.3%
JAVIER IGLESIAS VELASCO516
 
0.4%
GREGORIO VIEJO PÉREZ113
 
0.1%
SAREB56
 
< 0.1%
DIEGO HERNÁNDEZ GARCÍA51
 
< 0.1%
MTTO MV4949
 
< 0.1%
FACILITY MANAGEMENT COLEGIO ALEMÁN 240
 
< 0.1%
JULIO EXPÓSITO33
 
< 0.1%
SALVAMENTO MARITIMO - AVISOS12
 
< 0.1%
JUAN VAZQUEZ12
 
< 0.1%
Other values (4)8
 
< 0.1%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
javier516
20.2%
iglesias516
20.2%
velasco516
20.2%
gregorio113
 
4.4%
viejo113
 
4.4%
pérez113
 
4.4%
sareb56
 
2.2%
garcía51
 
2.0%
hernández51
 
2.0%
diego51
 
2.0%
Other values (27)458
17.9%

Most occurring characters

ValueCountFrequency (%)
120242
87.7%
E2327
 
1.7%
I2053
 
1.5%
A1958
 
1.4%
S1676
 
1.2%
V1230
 
0.9%
L1203
 
0.9%
O1150
 
0.8%
R1046
 
0.8%
G925
 
0.7%
Other values (24)3275
 
2.4%

Most occurring categories

ValueCountFrequency (%)
Space Separator120242
87.7%
Uppercase Letter16693
 
12.2%
Decimal Number138
 
0.1%
Dash Punctuation12
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
E2327
13.9%
I2053
12.3%
A1958
11.7%
S1676
10.0%
V1230
7.4%
L1203
7.2%
O1150
6.9%
R1046
6.3%
G925
 
5.5%
J674
 
4.0%
Other values (19)2451
14.7%
Decimal Number
ValueCountFrequency (%)
449
35.5%
949
35.5%
240
29.0%
Space Separator
ValueCountFrequency (%)
120242
100.0%
Dash Punctuation
ValueCountFrequency (%)
-12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common120392
87.8%
Latin16693
 
12.2%

Most frequent character per script

Latin
ValueCountFrequency (%)
E2327
13.9%
I2053
12.3%
A1958
11.7%
S1676
10.0%
V1230
7.4%
L1203
7.2%
O1150
6.9%
R1046
6.3%
G925
 
5.5%
J674
 
4.0%
Other values (19)2451
14.7%
Common
ValueCountFrequency (%)
120242
99.9%
449
 
< 0.1%
949
 
< 0.1%
240
 
< 0.1%
-12
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII136795
99.8%
None290
 
0.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
120242
87.9%
E2327
 
1.7%
I2053
 
1.5%
A1958
 
1.4%
S1676
 
1.2%
V1230
 
0.9%
L1203
 
0.9%
O1150
 
0.8%
R1046
 
0.8%
G925
 
0.7%
Other values (20)2985
 
2.2%
None
ValueCountFrequency (%)
É115
39.7%
Á91
31.4%
Í51
17.6%
Ó33
 
11.4%

Solicitante
Categorical

HIGH CORRELATION

Distinct38
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
118988 
RECEPCION
 
79
RECPCION
 
56
SAREB
 
56
Facility
 
40
Other values (33)
 
249

Length

Max length23
Median length1
Mean length1.033481769
Min length1

Characters and Unicode

Total characters123468
Distinct characters51
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique8 ?
Unique (%)< 0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
118988
99.6%
RECEPCION79
 
0.1%
RECPCION56
 
< 0.1%
SAREB56
 
< 0.1%
Facility40
 
< 0.1%
SGS38
 
< 0.1%
LIMPIEZA34
 
< 0.1%
Javier Recio A29
 
< 0.1%
Pilar Hernandez G24
 
< 0.1%
limpieza12
 
< 0.1%
Other values (28)112
 
0.1%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
recepcion86
 
12.2%
sareb56
 
7.9%
recpcion56
 
7.9%
limpieza50
 
7.1%
facility40
 
5.7%
sgs38
 
5.4%
g35
 
5.0%
a32
 
4.5%
pilar31
 
4.4%
hernandez31
 
4.4%
Other values (42)250
35.5%

Most occurring characters

ValueCountFrequency (%)
119213
96.6%
E336
 
0.3%
i319
 
0.3%
C291
 
0.2%
R263
 
0.2%
a231
 
0.2%
I226
 
0.2%
P217
 
0.2%
e193
 
0.2%
A183
 
0.1%
Other values (41)1996
 
1.6%

Most occurring categories

ValueCountFrequency (%)
Space Separator119213
96.6%
Uppercase Letter2462
 
2.0%
Lowercase Letter1772
 
1.4%
Decimal Number14
 
< 0.1%
Other Punctuation7
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
i319
18.0%
a231
13.0%
e193
10.9%
r168
9.5%
n118
 
6.7%
c113
 
6.4%
o113
 
6.4%
l106
 
6.0%
z59
 
3.3%
t52
 
2.9%
Other values (15)300
16.9%
Uppercase Letter
ValueCountFrequency (%)
E336
13.6%
C291
11.8%
R263
10.7%
I226
9.2%
P217
8.8%
A183
7.4%
S157
 
6.4%
O148
 
6.0%
N141
 
5.7%
G99
 
4.0%
Other values (12)401
16.3%
Other Punctuation
ValueCountFrequency (%)
.4
57.1%
,3
42.9%
Space Separator
ValueCountFrequency (%)
119213
100.0%
Decimal Number
ValueCountFrequency (%)
414
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common119234
96.6%
Latin4234
 
3.4%

Most frequent character per script

Latin
ValueCountFrequency (%)
E336
 
7.9%
i319
 
7.5%
C291
 
6.9%
R263
 
6.2%
a231
 
5.5%
I226
 
5.3%
P217
 
5.1%
e193
 
4.6%
A183
 
4.3%
r168
 
4.0%
Other values (37)1807
42.7%
Common
ValueCountFrequency (%)
119213
> 99.9%
414
 
< 0.1%
.4
 
< 0.1%
,3
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII123464
> 99.9%
None4
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
119213
96.6%
E336
 
0.3%
i319
 
0.3%
C291
 
0.2%
R263
 
0.2%
a231
 
0.2%
I226
 
0.2%
P217
 
0.2%
e193
 
0.2%
A183
 
0.1%
Other values (40)1992
 
1.6%
None
ValueCountFrequency (%)
ñ4
100.0%

Observaciones Aviso
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct82
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
119384 
SERVICIO REALIZADO EL 09/08/2022
 
4
Welcome pack planta 1 - taquilla 2002
 
1
Se cambia interruptor de ventilador, se limpia y desengrasa el mismo.
 
1
Modificación bancada Comité Dirección planta 2 - 25.03.22
 
1
Other values (77)
 
77

Length

Max length195
Median length1
Mean length1.02876084
Min length1

Characters and Unicode

Total characters122904
Distinct characters80
Distinct categories11 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique80 ?
Unique (%)0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
119384
99.9%
SERVICIO REALIZADO EL 09/08/20224
 
< 0.1%
Welcome pack planta 1 - taquilla 20021
 
< 0.1%
Se cambia interruptor de ventilador, se limpia y desengrasa el mismo.1
 
< 0.1%
Modificación bancada Comité Dirección planta 2 - 25.03.221
 
< 0.1%
Sala lactancia/primeros auxilios1
 
< 0.1%
Problemas diversos goteras planta 3ª1
 
< 0.1%
Revisión y mantenimiento paredes interior oficina1
 
< 0.1%
Distribución auditorio / sala transparencia 29.05.20211
 
< 0.1%
Revisión distribución 15 pax sala auditorio1
 
< 0.1%
Other values (72)72
 
0.1%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
planta28
 
5.5%
y14
 
2.8%
se14
 
2.8%
313
 
2.6%
de12
 
2.4%
sala12
 
2.4%
12
 
2.4%
28
 
1.6%
temperatura6
 
1.2%
a6
 
1.2%
Other values (286)380
75.2%

Most occurring characters

ValueCountFrequency (%)
119843
97.5%
a308
 
0.3%
i190
 
0.2%
e188
 
0.2%
o162
 
0.1%
n154
 
0.1%
r139
 
0.1%
t139
 
0.1%
l125
 
0.1%
s121
 
0.1%
Other values (70)1535
 
1.2%

Most occurring categories

ValueCountFrequency (%)
Space Separator119843
97.5%
Lowercase Letter2074
 
1.7%
Uppercase Letter712
 
0.6%
Decimal Number180
 
0.1%
Other Punctuation56
 
< 0.1%
Dash Punctuation17
 
< 0.1%
Open Punctuation7
 
< 0.1%
Close Punctuation7
 
< 0.1%
Other Letter5
 
< 0.1%
Control2
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a308
14.9%
i190
9.2%
e188
9.1%
o162
 
7.8%
n154
 
7.4%
r139
 
6.7%
t139
 
6.7%
l125
 
6.0%
s121
 
5.8%
c101
 
4.9%
Other values (21)447
21.6%
Uppercase Letter
ValueCountFrequency (%)
A87
12.2%
E83
11.7%
S61
 
8.6%
R60
 
8.4%
O58
 
8.1%
I49
 
6.9%
C39
 
5.5%
P38
 
5.3%
D36
 
5.1%
L36
 
5.1%
Other values (17)165
23.2%
Decimal Number
ValueCountFrequency (%)
251
28.3%
032
17.8%
332
17.8%
119
 
10.6%
511
 
6.1%
49
 
5.0%
88
 
4.4%
98
 
4.4%
66
 
3.3%
74
 
2.2%
Other Punctuation
ValueCountFrequency (%)
.30
53.6%
/15
26.8%
,9
 
16.1%
:2
 
3.6%
Control
ValueCountFrequency (%)
1
50.0%
1
50.0%
Space Separator
ValueCountFrequency (%)
119843
100.0%
Dash Punctuation
ValueCountFrequency (%)
-17
100.0%
Open Punctuation
ValueCountFrequency (%)
(7
100.0%
Close Punctuation
ValueCountFrequency (%)
)7
100.0%
Other Letter
ValueCountFrequency (%)
ª5
100.0%
Math Symbol
ValueCountFrequency (%)
+1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common120113
97.7%
Latin2791
 
2.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
a308
 
11.0%
i190
 
6.8%
e188
 
6.7%
o162
 
5.8%
n154
 
5.5%
r139
 
5.0%
t139
 
5.0%
l125
 
4.5%
s121
 
4.3%
c101
 
3.6%
Other values (49)1164
41.7%
Common
ValueCountFrequency (%)
119843
99.8%
251
 
< 0.1%
032
 
< 0.1%
332
 
< 0.1%
.30
 
< 0.1%
119
 
< 0.1%
-17
 
< 0.1%
/15
 
< 0.1%
511
 
< 0.1%
,9
 
< 0.1%
Other values (11)54
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII122859
> 99.9%
None45
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
119843
97.5%
a308
 
0.3%
i190
 
0.2%
e188
 
0.2%
o162
 
0.1%
n154
 
0.1%
r139
 
0.1%
t139
 
0.1%
l125
 
0.1%
s121
 
0.1%
Other values (63)1490
 
1.2%
None
ValueCountFrequency (%)
ó28
62.2%
é6
 
13.3%
ª5
 
11.1%
á2
 
4.4%
ñ2
 
4.4%
Á1
 
2.2%
í1
 
2.2%
Distinct470
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
Minimum2000-01-01 00:00:00
Maximum2022-12-31 00:00:00
Histogram with fixed size bins (bins=50)

Descripción de los Trabajos Realizados
Categorical

HIGH CARDINALITY

Distinct7141
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
109440 
Se realiza preventivo programado caldera centro. Sin anomalías durante la intervención.
 
90
analitica de agua torres
 
88
Se realiza preventivo programado bombas centro. Sin anomalías durante la intervención.
 
81
Se realiza mantenimiento conductivo diario.
 
80
Other values (7136)
 
9689

Length

Max length502
Median length1
Mean length10.5466987
Min length1

Characters and Unicode

Total characters1259993
Distinct characters114
Distinct categories17 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique6779 ?
Unique (%)5.7%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
109440
91.6%
Se realiza preventivo programado caldera centro. Sin anomalías durante la intervención.90
 
0.1%
analitica de agua torres88
 
0.1%
Se realiza preventivo programado bombas centro. Sin anomalías durante la intervención.81
 
0.1%
Se realiza mantenimiento conductivo diario.80
 
0.1%
LECTURA DE CONTADORES DE AGUA DIARIA75
 
0.1%
Se realiza preventivo programado enfriadora centro. Sin anomalías durante la intervención.75
 
0.1%
Se realiza ronda general de clima en edificio y se ajusta la temperatura en todas las plantas73
 
0.1%
chequeo de la instalacion72
 
0.1%
parada69
 
0.1%
Other values (7131)9325
 
7.8%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
de16934
 
9.2%
se12015
 
6.5%
y5954
 
3.2%
la5947
 
3.2%
en4725
 
2.6%
que2812
 
1.5%
el2785
 
1.5%
a2660
 
1.4%
realiza2292
 
1.2%
del1781
 
1.0%
Other values (10367)126180
68.5%

Most occurring characters

ValueCountFrequency (%)
280877
22.3%
a101616
 
8.1%
e100787
 
8.0%
r59949
 
4.8%
o58686
 
4.7%
n57619
 
4.6%
i56213
 
4.5%
s45714
 
3.6%
t40299
 
3.2%
d38479
 
3.1%
Other values (104)419754
33.3%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter780162
61.9%
Space Separator280938
 
22.3%
Uppercase Letter152020
 
12.1%
Other Punctuation18356
 
1.5%
Decimal Number17142
 
1.4%
Control7840
 
0.6%
Dash Punctuation2045
 
0.2%
Open Punctuation377
 
< 0.1%
Close Punctuation361
 
< 0.1%
Other Symbol271
 
< 0.1%
Other values (7)481
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a101616
13.0%
e100787
12.9%
r59949
 
7.7%
o58686
 
7.5%
n57619
 
7.4%
i56213
 
7.2%
s45714
 
5.9%
t40299
 
5.2%
d38479
 
4.9%
c37687
 
4.8%
Other values (24)183113
23.5%
Uppercase Letter
ValueCountFrequency (%)
A20506
13.5%
E18512
12.2%
S16235
10.7%
R10966
 
7.2%
O10811
 
7.1%
N9108
 
6.0%
D8716
 
5.7%
I8574
 
5.6%
C8392
 
5.5%
T7320
 
4.8%
Other values (24)32880
21.6%
Other Punctuation
ValueCountFrequency (%)
.11726
63.9%
,5112
27.8%
:688
 
3.7%
/626
 
3.4%
"126
 
0.7%
%52
 
0.3%
;8
 
< 0.1%
'3
 
< 0.1%
@3
 
< 0.1%
&3
 
< 0.1%
Other values (4)9
 
< 0.1%
Decimal Number
ValueCountFrequency (%)
13618
21.1%
23430
20.0%
02142
12.5%
31756
10.2%
41297
 
7.6%
51265
 
7.4%
61040
 
6.1%
8906
 
5.3%
7869
 
5.1%
9819
 
4.8%
Math Symbol
ValueCountFrequency (%)
+235
93.6%
=11
 
4.4%
>3
 
1.2%
<2
 
0.8%
Control
ValueCountFrequency (%)
4709
60.1%
3124
39.8%
7
 
0.1%
Space Separator
ValueCountFrequency (%)
280877
> 99.9%
 61
 
< 0.1%
Dash Punctuation
ValueCountFrequency (%)
-2043
99.9%
2
 
0.1%
Other Letter
ValueCountFrequency (%)
º112
50.9%
ª108
49.1%
Modifier Symbol
ValueCountFrequency (%)
`1
50.0%
´1
50.0%
Open Punctuation
ValueCountFrequency (%)
(377
100.0%
Close Punctuation
ValueCountFrequency (%)
)361
100.0%
Other Symbol
ValueCountFrequency (%)
°271
100.0%
Initial Punctuation
ValueCountFrequency (%)
2
100.0%
Final Punctuation
ValueCountFrequency (%)
2
100.0%
Connector Punctuation
ValueCountFrequency (%)
_2
100.0%
Other Number
ValueCountFrequency (%)
³2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin932402
74.0%
Common327591
 
26.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
a101616
 
10.9%
e100787
 
10.8%
r59949
 
6.4%
o58686
 
6.3%
n57619
 
6.2%
i56213
 
6.0%
s45714
 
4.9%
t40299
 
4.3%
d38479
 
4.1%
c37687
 
4.0%
Other values (60)335353
36.0%
Common
ValueCountFrequency (%)
280877
85.7%
.11726
 
3.6%
,5112
 
1.6%
4709
 
1.4%
13618
 
1.1%
23430
 
1.0%
3124
 
1.0%
02142
 
0.7%
-2043
 
0.6%
31756
 
0.5%
Other values (34)9054
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII1242885
98.6%
None17099
 
1.4%
Punctuation9
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
280877
22.6%
a101616
 
8.2%
e100787
 
8.1%
r59949
 
4.8%
o58686
 
4.7%
n57619
 
4.6%
i56213
 
4.5%
s45714
 
3.7%
t40299
 
3.2%
d38479
 
3.1%
Other values (76)402646
32.4%
None
ValueCountFrequency (%)
ó8325
48.7%
í2972
 
17.4%
á2335
 
13.7%
é1026
 
6.0%
ú618
 
3.6%
ñ430
 
2.5%
Ñ303
 
1.8%
°271
 
1.6%
Ó267
 
1.6%
º112
 
0.7%
Other values (14)440
 
2.6%
Punctuation
ValueCountFrequency (%)
3
33.3%
2
22.2%
2
22.2%
2
22.2%

Observaciones
Categorical

HIGH CARDINALITY

Distinct1034
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
118262 
material en almacén
 
36
MATERIAL EN ALMACÉN
 
27
[Error en check list]
 
26
Inspección y toma de datos de instalación eléctrica, los resultados se detallaran en informe emitido por departamento eléctrico.
 
22
Other values (1029)
 
1095

Length

Max length501
Median length1
Mean length1.472503097
Min length1

Characters and Unicode

Total characters175917
Distinct characters101
Distinct categories13 ?
Distinct scripts2 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique993 ?
Unique (%)0.8%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
118262
99.0%
material en almacén36
 
< 0.1%
MATERIAL EN ALMACÉN27
 
< 0.1%
[Error en check list]26
 
< 0.1%
Inspección y toma de datos de instalación eléctrica, los resultados se detallaran en informe emitido por departamento eléctrico.22
 
< 0.1%
DOBLE PERSONAL8
 
< 0.1%
trabajo realizado por Alberto7
 
< 0.1%
P529875
 
< 0.1%
Material en almacén5
 
< 0.1%
SERVICIO REALIZADO EL 09/08/20224
 
< 0.1%
Other values (1024)1066
 
0.9%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
de589
 
6.4%
en310
 
3.3%
se259
 
2.8%
y207
 
2.2%
la143
 
1.5%
a116
 
1.3%
116
 
1.3%
por116
 
1.3%
el111
 
1.2%
almacén100
 
1.1%
Other values (2885)7204
77.7%

Most occurring characters

ValueCountFrequency (%)
126342
71.8%
a4205
 
2.4%
e3994
 
2.3%
o2594
 
1.5%
r2467
 
1.4%
i2304
 
1.3%
n2124
 
1.2%
l1901
 
1.1%
s1841
 
1.0%
t1662
 
0.9%
Other values (91)26483
 
15.1%

Most occurring categories

ValueCountFrequency (%)
Space Separator126342
71.8%
Lowercase Letter31979
 
18.2%
Uppercase Letter9694
 
5.5%
Decimal Number5636
 
3.2%
Other Punctuation1290
 
0.7%
Control489
 
0.3%
Dash Punctuation248
 
0.1%
Close Punctuation74
 
< 0.1%
Open Punctuation73
 
< 0.1%
Math Symbol44
 
< 0.1%
Other values (3)48
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a4205
13.1%
e3994
12.5%
o2594
 
8.1%
r2467
 
7.7%
i2304
 
7.2%
n2124
 
6.6%
l1901
 
5.9%
s1841
 
5.8%
t1662
 
5.2%
d1637
 
5.1%
Other values (24)7250
22.7%
Uppercase Letter
ValueCountFrequency (%)
A1306
13.5%
E995
 
10.3%
S682
 
7.0%
R672
 
6.9%
O670
 
6.9%
N629
 
6.5%
I600
 
6.2%
L594
 
6.1%
C488
 
5.0%
T477
 
4.9%
Other values (23)2581
26.6%
Decimal Number
ValueCountFrequency (%)
0815
14.5%
2751
13.3%
1728
12.9%
6663
11.8%
5599
10.6%
3486
8.6%
4460
8.2%
7414
7.3%
9399
7.1%
8321
 
5.7%
Other Punctuation
ValueCountFrequency (%)
.569
44.1%
:253
19.6%
/226
 
17.5%
,180
 
14.0%
!37
 
2.9%
?9
 
0.7%
"8
 
0.6%
@8
 
0.6%
Control
ValueCountFrequency (%)
281
57.5%
205
41.9%
3
 
0.6%
Dash Punctuation
ValueCountFrequency (%)
-208
83.9%
40
 
16.1%
Close Punctuation
ValueCountFrequency (%)
)41
55.4%
]33
44.6%
Open Punctuation
ValueCountFrequency (%)
(40
54.8%
[33
45.2%
Math Symbol
ValueCountFrequency (%)
=34
77.3%
+10
 
22.7%
Other Letter
ValueCountFrequency (%)
º27
61.4%
ª17
38.6%
Space Separator
ValueCountFrequency (%)
126342
100.0%
Currency Symbol
ValueCountFrequency (%)
3
100.0%
Connector Punctuation
ValueCountFrequency (%)
_1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common134200
76.3%
Latin41717
 
23.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
a4205
 
10.1%
e3994
 
9.6%
o2594
 
6.2%
r2467
 
5.9%
i2304
 
5.5%
n2124
 
5.1%
l1901
 
4.6%
s1841
 
4.4%
t1662
 
4.0%
d1637
 
3.9%
Other values (59)16988
40.7%
Common
ValueCountFrequency (%)
126342
94.1%
0815
 
0.6%
2751
 
0.6%
1728
 
0.5%
6663
 
0.5%
5599
 
0.4%
.569
 
0.4%
3486
 
0.4%
4460
 
0.3%
7414
 
0.3%
Other values (22)2373
 
1.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII175160
99.6%
None714
 
0.4%
Punctuation40
 
< 0.1%
Currency Symbols3
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
126342
72.1%
a4205
 
2.4%
e3994
 
2.3%
o2594
 
1.5%
r2467
 
1.4%
i2304
 
1.3%
n2124
 
1.2%
l1901
 
1.1%
s1841
 
1.1%
t1662
 
0.9%
Other values (72)25726
 
14.7%
None
ValueCountFrequency (%)
ó249
34.9%
é149
20.9%
í64
 
9.0%
á57
 
8.0%
ú45
 
6.3%
É37
 
5.2%
º27
 
3.8%
ñ18
 
2.5%
Ó17
 
2.4%
ª17
 
2.4%
Other values (7)34
 
4.8%
Punctuation
ValueCountFrequency (%)
40
100.0%
Currency Symbols
ValueCountFrequency (%)
3
100.0%

Centro de trabajo
Categorical

HIGH CARDINALITY

Distinct378
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
COLEGIO ALEMÁN DE MADRID - SAT 1 - COLEGIO ALEMÁN DE MADRID
 
6323
MANC. CP R. GOMEZ DE LA SERNA, 47 - SAT 1 - RAMON GOMEZ DE LA SERNA 47
 
5628
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - MUTUA - CASTELLANA 33
 
5236
AG MADRID BARAJAS SL - SAT 2 - TRESPADERNE 29 (CUSHMAN & WAKEFIELD)
 
3686
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - ALFREDO MAHOU
 
3663
Other values (373)
94932 

Length

Max length100
Median length81
Mean length60.3851659
Min length25

Characters and Unicode

Total characters7214095
Distinct characters57
Distinct categories9 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique12 ?
Unique (%)< 0.1%

Sample

1st rowREX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34
2nd rowREX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34
3rd rowVP HOTELES - SAT 2 - VP PLAZA DE ESPAÑA DESIGN
4th rowTORRE RIOJA MADRID S.A. - SAT 1 - OSIRIS 11
5th rowSANITAS MAYORES, S.L. - SAT 2 - SANITAS ARTURO SORIA

Common Values

ValueCountFrequency (%)
COLEGIO ALEMÁN DE MADRID - SAT 1 - COLEGIO ALEMÁN DE MADRID6323
 
5.3%
MANC. CP R. GOMEZ DE LA SERNA, 47 - SAT 1 - RAMON GOMEZ DE LA SERNA 475628
 
4.7%
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - MUTUA - CASTELLANA 335236
 
4.4%
AG MADRID BARAJAS SL - SAT 2 - TRESPADERNE 29 (CUSHMAN & WAKEFIELD)3686
 
3.1%
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - ALFREDO MAHOU3663
 
3.1%
ATAM PARA EL APOYO FAMILIAR - SAT 1 - ATAM - POZUELO3491
 
2.9%
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - CASTELLANA 36-383378
 
2.8%
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - AV EUROPA 223293
 
2.8%
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - CASTELLANA 503188
 
2.7%
MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - EDIFICIO PIRAMIDE (CASTELLANA 31)2982
 
2.5%
Other values (368)78600
65.8%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
261956
 
17.9%
sat117377
 
8.0%
175151
 
5.1%
de66888
 
4.6%
240226
 
2.8%
mutua38809
 
2.7%
a30374
 
2.1%
seguros29927
 
2.0%
sociedad29902
 
2.0%
prima29854
 
2.0%
Other values (879)740665
50.7%

Most occurring characters

ValueCountFrequency (%)
1341742
18.6%
A851982
 
11.8%
S449750
 
6.2%
E446817
 
6.2%
I385580
 
5.3%
R317926
 
4.4%
O314616
 
4.4%
L297771
 
4.1%
T296293
 
4.1%
-264596
 
3.7%
Other values (47)2247022
31.1%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter5092790
70.6%
Space Separator1341742
 
18.6%
Decimal Number281496
 
3.9%
Dash Punctuation264596
 
3.7%
Other Punctuation210087
 
2.9%
Open Punctuation10781
 
0.1%
Close Punctuation10781
 
0.1%
Lowercase Letter1127
 
< 0.1%
Other Letter695
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A851982
16.7%
S449750
 
8.8%
E446817
 
8.8%
I385580
 
7.6%
R317926
 
6.2%
O314616
 
6.2%
L297771
 
5.8%
T296293
 
5.8%
D258848
 
5.1%
M245253
 
4.8%
Other values (23)1227954
24.1%
Decimal Number
ValueCountFrequency (%)
1104018
37.0%
257043
20.3%
331876
 
11.3%
420964
 
7.4%
719816
 
7.0%
613290
 
4.7%
89787
 
3.5%
59079
 
3.2%
08580
 
3.0%
97043
 
2.5%
Lowercase Letter
ValueCountFrequency (%)
y403
35.8%
c181
16.1%
e181
16.1%
i181
16.1%
l181
16.1%
Other Punctuation
ValueCountFrequency (%)
.114837
54.7%
,90088
42.9%
&5081
 
2.4%
/81
 
< 0.1%
Space Separator
ValueCountFrequency (%)
1341742
100.0%
Dash Punctuation
ValueCountFrequency (%)
-264596
100.0%
Open Punctuation
ValueCountFrequency (%)
(10781
100.0%
Close Punctuation
ValueCountFrequency (%)
)10781
100.0%
Other Letter
ValueCountFrequency (%)
º695
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin5094612
70.6%
Common2119483
29.4%

Most frequent character per script

Latin
ValueCountFrequency (%)
A851982
16.7%
S449750
 
8.8%
E446817
 
8.8%
I385580
 
7.6%
R317926
 
6.2%
O314616
 
6.2%
L297771
 
5.8%
T296293
 
5.8%
D258848
 
5.1%
M245253
 
4.8%
Other values (29)1229776
24.1%
Common
ValueCountFrequency (%)
1341742
63.3%
-264596
 
12.5%
.114837
 
5.4%
1104018
 
4.9%
,90088
 
4.3%
257043
 
2.7%
331876
 
1.5%
420964
 
1.0%
719816
 
0.9%
613290
 
0.6%
Other values (8)61213
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII7150431
99.1%
None63664
 
0.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1341742
18.8%
A851982
 
11.9%
S449750
 
6.3%
E446817
 
6.2%
I385580
 
5.4%
R317926
 
4.4%
O314616
 
4.4%
L297771
 
4.2%
T296293
 
4.1%
-264596
 
3.7%
Other values (39)2183358
30.5%
None
ValueCountFrequency (%)
Ñ38645
60.7%
Á15323
 
24.1%
Ó5938
 
9.3%
Í2612
 
4.1%
º695
 
1.1%
É288
 
0.5%
Ú147
 
0.2%
Ü16
 
< 0.1%

Árbol departamental
Categorical

HIGH CARDINALITY

Distinct1014
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
EDIFICIO - IDOM CONSULTING
 
2474
EDIFICIO - MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - CASTELLANA 33 - EDIFICIO
 
1931
EDIFICIO - CANOE
 
1925
EDIFICIO - COLEGIO ALEMÁN - Colegio - PUERTAS - INTERIORES
 
1752
EDIFICIO - VELAZQUEZ 34
 
1533
Other values (1009)
109853 

Length

Max length113
Median length95
Mean length54.72662973
Min length16

Characters and Unicode

Total characters6538081
Distinct characters75
Distinct categories9 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique17 ?
Unique (%)< 0.1%

Sample

1st rowEDIFICIO - VELAZQUEZ 34
2nd rowEDIFICIO - VELAZQUEZ 34
3rd rowSAT - RUTA 03 - VP PLAZA DE ESPAÑA DESIGN
4th rowEDIFICIO - OSIRIS 11 (ROCHE) - PLANTA QUINTA - TERRAZA
5th rowSAT - RUTA 09 - SANITAS MAYORES, S.L. - SANITAS ARTURO SORIA

Common Values

ValueCountFrequency (%)
EDIFICIO - IDOM CONSULTING2474
 
2.1%
EDIFICIO - MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - CASTELLANA 33 - EDIFICIO1931
 
1.6%
EDIFICIO - CANOE1925
 
1.6%
EDIFICIO - COLEGIO ALEMÁN - Colegio - PUERTAS - INTERIORES1752
 
1.5%
EDIFICIO - VELAZQUEZ 341533
 
1.3%
EDIFICIO - OSIRIS 11 (ROCHE) - AZOTEA - PLANTA INSTALACIONES1245
 
1.0%
EDIFICIO - TRESPADERME 29 - EDIFICIO1242
 
1.0%
EDIFICIO - TRESPADERME 29 - PCI1187
 
1.0%
EDIFICIO - ATAM - POZUELO - EDIFICIO C11018
 
0.9%
EDIFICIO - ATAM - POZUELO - EDIFICIO A952
 
0.8%
Other values (1004)104209
87.2%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
308609
24.1%
edificio89289
 
7.0%
de47596
 
3.7%
sat44289
 
3.5%
ruta42871
 
3.3%
a31537
 
2.5%
seguros29719
 
2.3%
fija29719
 
2.3%
prima29719
 
2.3%
sociedad29719
 
2.3%
Other values (887)599494
46.7%

Most occurring characters

ValueCountFrequency (%)
1163183
17.8%
A690564
 
10.6%
I517887
 
7.9%
E428906
 
6.6%
O320974
 
4.9%
-316712
 
4.8%
S289188
 
4.4%
R278519
 
4.3%
D273069
 
4.2%
T257178
 
3.9%
Other values (65)2001901
30.6%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter4626438
70.8%
Space Separator1163183
 
17.8%
Dash Punctuation316712
 
4.8%
Decimal Number265588
 
4.1%
Lowercase Letter74266
 
1.1%
Other Punctuation56464
 
0.9%
Open Punctuation17374
 
0.3%
Close Punctuation17374
 
0.3%
Other Letter682
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A690564
14.9%
I517887
11.2%
E428906
 
9.3%
O320974
 
6.9%
S289188
 
6.3%
R278519
 
6.0%
D273069
 
5.9%
T257178
 
5.6%
C246136
 
5.3%
L221705
 
4.8%
Other values (22)1102312
23.8%
Lowercase Letter
ValueCountFrequency (%)
o12082
16.3%
a10528
14.2%
i8300
11.2%
e7280
9.8%
r5710
7.7%
t5268
7.1%
n4963
6.7%
l4943
6.7%
d3387
 
4.6%
u2804
 
3.8%
Other values (15)9001
12.1%
Decimal Number
ValueCountFrequency (%)
057192
21.5%
152049
19.6%
347802
18.0%
224236
9.1%
514870
 
5.6%
614545
 
5.5%
714320
 
5.4%
414250
 
5.4%
913845
 
5.2%
812479
 
4.7%
Other Punctuation
ValueCountFrequency (%)
,40911
72.5%
.14413
 
25.5%
&1140
 
2.0%
Space Separator
ValueCountFrequency (%)
1163183
100.0%
Dash Punctuation
ValueCountFrequency (%)
-316712
100.0%
Open Punctuation
ValueCountFrequency (%)
(17374
100.0%
Close Punctuation
ValueCountFrequency (%)
)17374
100.0%
Other Letter
ValueCountFrequency (%)
º682
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin4701386
71.9%
Common1836695
 
28.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
A690564
14.7%
I517887
11.0%
E428906
 
9.1%
O320974
 
6.8%
S289188
 
6.2%
R278519
 
5.9%
D273069
 
5.8%
T257178
 
5.5%
C246136
 
5.2%
L221705
 
4.7%
Other values (48)1177260
25.0%
Common
ValueCountFrequency (%)
1163183
63.3%
-316712
 
17.2%
057192
 
3.1%
152049
 
2.8%
347802
 
2.6%
,40911
 
2.2%
224236
 
1.3%
(17374
 
0.9%
)17374
 
0.9%
514870
 
0.8%
Other values (7)84992
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII6481954
99.1%
None56127
 
0.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1163183
17.9%
A690564
 
10.7%
I517887
 
8.0%
E428906
 
6.6%
O320974
 
5.0%
-316712
 
4.9%
S289188
 
4.5%
R278519
 
4.3%
D273069
 
4.2%
T257178
 
4.0%
Other values (56)1945774
30.0%
None
ValueCountFrequency (%)
Ñ32942
58.7%
Á11332
 
20.2%
Ó5814
 
10.4%
Í3225
 
5.7%
É1069
 
1.9%
º682
 
1.2%
í677
 
1.2%
ó352
 
0.6%
Ú34
 
0.1%

Tipo Intervención
Categorical

HIGH CORRELATION

Distinct43
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
Preventivo - Climatización
25431 
Preventivo - AFS
24143 
Preventivo
14183 
Preventivo - Legionella
10968 
Preventivo - Electricidad - BT
7302 
Other values (38)
37441 

Length

Max length30
Median length28
Mean length18.74938059
Min length1

Characters and Unicode

Total characters2239951
Distinct characters42
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

1st rowPreventivo - Electricidad - BT
2nd rowPreventivo - Electricidad - BT
3rd rowPreventivo - AFS
4th rowPreventivo - Electricidad - BT
5th rowPreventivo - Calefacción y ACS

Common Values

ValueCountFrequency (%)
Preventivo - Climatización25431
21.3%
Preventivo - AFS24143
20.2%
Preventivo14183
11.9%
Preventivo - Legionella10968
9.2%
Preventivo - Electricidad - BT7302
 
6.1%
Preventivo - PCI5344
 
4.5%
Preventivo - Calefacción y ACS5223
 
4.4%
Preventivo - Frío5180
 
4.3%
Preventivo - ACS4936
 
4.1%
Conductivo4504
 
3.8%
Other values (33)12254
10.3%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
preventivo105319
32.1%
99762
30.4%
climatización25440
 
7.8%
afs24143
 
7.4%
legionella10968
 
3.3%
acs10159
 
3.1%
electricidad7549
 
2.3%
bt7302
 
2.2%
pci5344
 
1.6%
calefacción5224
 
1.6%
Other values (33)26731
 
8.2%

Most occurring characters

ValueCountFrequency (%)
e250955
11.2%
i228514
10.2%
v217825
 
9.7%
214675
 
9.6%
n153667
 
6.9%
t148250
 
6.6%
o137621
 
6.1%
r124363
 
5.6%
P111449
 
5.0%
-99762
 
4.5%
Other values (32)552870
24.7%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter1613726
72.0%
Uppercase Letter311788
 
13.9%
Space Separator214675
 
9.6%
Dash Punctuation99762
 
4.5%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e250955
15.6%
i228514
14.2%
v217825
13.5%
n153667
9.5%
t148250
9.2%
o137621
8.5%
r124363
7.7%
a85412
 
5.3%
l61653
 
3.8%
c59538
 
3.7%
Other values (14)145928
9.0%
Uppercase Letter
ValueCountFrequency (%)
P111449
35.7%
C53208
17.1%
S35849
 
11.5%
A35724
 
11.5%
F31185
 
10.0%
L10968
 
3.5%
T8316
 
2.7%
E7563
 
2.4%
B7363
 
2.4%
I5344
 
1.7%
Other values (6)4819
 
1.5%
Space Separator
ValueCountFrequency (%)
214675
100.0%
Dash Punctuation
ValueCountFrequency (%)
-99762
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin1925514
86.0%
Common314437
 
14.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
e250955
13.0%
i228514
11.9%
v217825
11.3%
n153667
 
8.0%
t148250
 
7.7%
o137621
 
7.1%
r124363
 
6.5%
P111449
 
5.8%
a85412
 
4.4%
l61653
 
3.2%
Other values (30)405805
21.1%
Common
ValueCountFrequency (%)
214675
68.3%
-99762
31.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII2201850
98.3%
None38101
 
1.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
e250955
11.4%
i228514
10.4%
v217825
9.9%
214675
9.7%
n153667
 
7.0%
t148250
 
6.7%
o137621
 
6.3%
r124363
 
5.6%
P111449
 
5.1%
-99762
 
4.5%
Other values (29)514769
23.4%
None
ValueCountFrequency (%)
ó31344
82.3%
í5596
 
14.7%
é1161
 
3.0%

Tipo de Incidencia
Categorical

HIGH CORRELATION

Distinct21
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
115176 
Mtto General
 
1154
Climatización
 
852
Eléctrica
 
795
Fontanería
 
546
Other values (16)
 
945

Length

Max length15
Median length1
Mean length1.360866508
Min length1

Characters and Unicode

Total characters162580
Distinct characters37
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
115176
96.4%
Mtto General1154
 
1.0%
Climatización852
 
0.7%
Eléctrica795
 
0.7%
Fontanería546
 
0.5%
Ventilación284
 
0.2%
Calefacción164
 
0.1%
Cerrajería159
 
0.1%
Agua Caliente58
 
< 0.1%
Frío Industrial53
 
< 0.1%
Other values (11)227
 
0.2%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
mtto1154
20.7%
general1154
20.7%
climatización852
15.3%
eléctrica795
14.2%
fontanería546
9.8%
ventilación284
 
5.1%
calefacción164
 
2.9%
cerrajería159
 
2.8%
agua58
 
1.0%
caliente58
 
1.0%
Other values (14)359
 
6.4%

Most occurring characters

ValueCountFrequency (%)
116467
71.6%
a6045
 
3.7%
t4982
 
3.1%
i4491
 
2.8%
n4054
 
2.5%
e3845
 
2.4%
l3430
 
2.1%
r3203
 
2.0%
c3134
 
1.9%
o1842
 
1.1%
Other values (27)11087
 
6.8%

Most occurring categories

ValueCountFrequency (%)
Space Separator116467
71.6%
Lowercase Letter40480
 
24.9%
Uppercase Letter5633
 
3.5%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a6045
14.9%
t4982
12.3%
i4491
11.1%
n4054
10.0%
e3845
9.5%
l3430
8.5%
r3203
7.9%
c3134
7.7%
o1842
 
4.6%
ó1300
 
3.2%
Other values (13)4154
10.3%
Uppercase Letter
ValueCountFrequency (%)
C1286
22.8%
M1176
20.9%
G1154
20.5%
E818
14.5%
F619
11.0%
V284
 
5.0%
A99
 
1.8%
I70
 
1.2%
P57
 
1.0%
O26
 
0.5%
Other values (3)44
 
0.8%
Space Separator
ValueCountFrequency (%)
116467
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common116467
71.6%
Latin46113
 
28.4%

Most frequent character per script

Latin
ValueCountFrequency (%)
a6045
13.1%
t4982
10.8%
i4491
9.7%
n4054
8.8%
e3845
 
8.3%
l3430
 
7.4%
r3203
 
6.9%
c3134
 
6.8%
o1842
 
4.0%
ó1300
 
2.8%
Other values (26)9787
21.2%
Common
ValueCountFrequency (%)
116467
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII159706
98.2%
None2874
 
1.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
116467
72.9%
a6045
 
3.8%
t4982
 
3.1%
i4491
 
2.8%
n4054
 
2.5%
e3845
 
2.4%
l3430
 
2.1%
r3203
 
2.0%
c3134
 
2.0%
o1842
 
1.2%
Other values (24)8213
 
5.1%
None
ValueCountFrequency (%)
ó1300
45.2%
é795
27.7%
í779
27.1%

Prioridad
Categorical

HIGH CORRELATION

Distinct5
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
Baja
69723 
Media
41258 
 
6660
Urgente
 
1712
Alta
 
115

Length

Max length7
Median length4
Mean length4.221096863
Min length1

Characters and Unicode

Total characters504286
Distinct characters15
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowBaja
2nd rowBaja
3rd rowBaja
4th rowBaja
5th rowMedia

Common Values

ValueCountFrequency (%)
Baja69723
58.4%
Media41258
34.5%
6660
 
5.6%
Urgente1712
 
1.4%
Alta115
 
0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

ValueCountFrequency (%)
baja69723
61.8%
media41258
36.6%
urgente1712
 
1.5%
alta115
 
0.1%

Most occurring characters

ValueCountFrequency (%)
a180819
35.9%
B69723
 
13.8%
j69723
 
13.8%
e44682
 
8.9%
M41258
 
8.2%
d41258
 
8.2%
i41258
 
8.2%
6660
 
1.3%
t1827
 
0.4%
U1712
 
0.3%
Other values (5)5366
 
1.1%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter384818
76.3%
Uppercase Letter112808
 
22.4%
Space Separator6660
 
1.3%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a180819
47.0%
j69723
 
18.1%
e44682
 
11.6%
d41258
 
10.7%
i41258
 
10.7%
t1827
 
0.5%
r1712
 
0.4%
g1712
 
0.4%
n1712
 
0.4%
l115
 
< 0.1%
Uppercase Letter
ValueCountFrequency (%)
B69723
61.8%
M41258
36.6%
U1712
 
1.5%
A115
 
0.1%
Space Separator
ValueCountFrequency (%)
6660
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin497626
98.7%
Common6660
 
1.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
a180819
36.3%
B69723
 
14.0%
j69723
 
14.0%
e44682
 
9.0%
M41258
 
8.3%
d41258
 
8.3%
i41258
 
8.3%
t1827
 
0.4%
U1712
 
0.3%
r1712
 
0.3%
Other values (4)3654
 
0.7%
Common
ValueCountFrequency (%)
6660
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII504286
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
a180819
35.9%
B69723
 
13.8%
j69723
 
13.8%
e44682
 
8.9%
M41258
 
8.2%
d41258
 
8.2%
i41258
 
8.2%
6660
 
1.3%
t1827
 
0.4%
U1712
 
0.3%
Other values (5)5366
 
1.1%

Coste MOI
Categorical

HIGH CORRELATION

Distinct39
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
0.00 €
119061 
71.26 €
 
133
15.09 €
 
55
17.24 €
 
29
14.50 €
 
24
Other values (34)
 
166

Length

Max length9
Median length7
Mean length7.003004989
Min length7

Characters and Unicode

Total characters836635
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique8 ?
Unique (%)< 0.1%

Sample

1st row 0.00 €
2nd row 0.00 €
3rd row 0.00 €
4th row 0.00 €
5th row 0.00 €

Common Values

ValueCountFrequency (%)
0.00 €119061
99.7%
71.26 €133
 
0.1%
15.09 €55
 
< 0.1%
17.24 €29
 
< 0.1%
14.50 €24
 
< 0.1%
18.10 €21
 
< 0.1%
29.00 €15
 
< 0.1%
0.08 €12
 
< 0.1%
0.10 €10
 
< 0.1%
8.50 €10
 
< 0.1%
Other values (29)98
 
0.1%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
119468
50.0%
0.00119061
49.8%
71.26133
 
0.1%
15.0955
 
< 0.1%
17.2429
 
< 0.1%
14.5024
 
< 0.1%
18.1021
 
< 0.1%
29.0015
 
< 0.1%
0.0812
 
< 0.1%
8.5010
 
< 0.1%
Other values (30)108
 
< 0.1%

Most occurring characters

ValueCountFrequency (%)
0357482
42.7%
238936
28.6%
.119468
 
14.3%
119468
 
14.3%
1336
 
< 0.1%
7207
 
< 0.1%
2195
 
< 0.1%
6165
 
< 0.1%
5129
 
< 0.1%
474
 
< 0.1%
Other values (3)175
 
< 0.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number358763
42.9%
Space Separator238936
28.6%
Other Punctuation119468
 
14.3%
Currency Symbol119468
 
14.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0357482
99.6%
1336
 
0.1%
7207
 
0.1%
2195
 
0.1%
6165
 
< 0.1%
5129
 
< 0.1%
474
 
< 0.1%
971
 
< 0.1%
866
 
< 0.1%
338
 
< 0.1%
Space Separator
ValueCountFrequency (%)
238936
100.0%
Other Punctuation
ValueCountFrequency (%)
.119468
100.0%
Currency Symbol
ValueCountFrequency (%)
119468
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common836635
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0357482
42.7%
238936
28.6%
.119468
 
14.3%
119468
 
14.3%
1336
 
< 0.1%
7207
 
< 0.1%
2195
 
< 0.1%
6165
 
< 0.1%
5129
 
< 0.1%
474
 
< 0.1%
Other values (3)175
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII717167
85.7%
Currency Symbols119468
 
14.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0357482
49.8%
238936
33.3%
.119468
 
16.7%
1336
 
< 0.1%
7207
 
< 0.1%
2195
 
< 0.1%
6165
 
< 0.1%
5129
 
< 0.1%
474
 
< 0.1%
971
 
< 0.1%
Other values (2)104
 
< 0.1%
Currency Symbols
ValueCountFrequency (%)
119468
100.0%

Coste MOE
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
0.00 €
119468 

Length

Max length7
Median length7
Mean length7
Min length7

Characters and Unicode

Total characters836276
Distinct characters4
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row 0.00 €
2nd row 0.00 €
3rd row 0.00 €
4th row 0.00 €
5th row 0.00 €

Common Values

ValueCountFrequency (%)
0.00 €119468
100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

ValueCountFrequency (%)
0.00119468
50.0%
119468
50.0%

Most occurring characters

ValueCountFrequency (%)
0358404
42.9%
238936
28.6%
.119468
 
14.3%
119468
 
14.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number358404
42.9%
Space Separator238936
28.6%
Other Punctuation119468
 
14.3%
Currency Symbol119468
 
14.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0358404
100.0%
Space Separator
ValueCountFrequency (%)
238936
100.0%
Other Punctuation
ValueCountFrequency (%)
.119468
100.0%
Currency Symbol
ValueCountFrequency (%)
119468
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common836276
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0358404
42.9%
238936
28.6%
.119468
 
14.3%
119468
 
14.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII716808
85.7%
Currency Symbols119468
 
14.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0358404
50.0%
238936
33.3%
.119468
 
16.7%
Currency Symbols
ValueCountFrequency (%)
119468
100.0%

Coste Material
Categorical

HIGH CARDINALITY

Distinct192
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
0.00 €
119275 
39.00 €
 
2
35.00 €
 
2
153.76 €
 
1
52.00 €
 
1
Other values (187)
 
187

Length

Max length10
Median length7
Mean length7.002410687
Min length7

Characters and Unicode

Total characters836564
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique189 ?
Unique (%)0.2%

Sample

1st row 0.00 €
2nd row 0.00 €
3rd row 0.00 €
4th row 0.00 €
5th row 0.00 €

Common Values

ValueCountFrequency (%)
0.00 €119275
99.8%
39.00 €2
 
< 0.1%
35.00 €2
 
< 0.1%
153.76 €1
 
< 0.1%
52.00 €1
 
< 0.1%
682.50 €1
 
< 0.1%
39.59 €1
 
< 0.1%
1.80 €1
 
< 0.1%
150.36 €1
 
< 0.1%
16.94 €1
 
< 0.1%
Other values (182)182
 
0.2%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
119468
50.0%
0.00119275
49.9%
39.002
 
< 0.1%
35.002
 
< 0.1%
59.821
 
< 0.1%
61.981
 
< 0.1%
16.791
 
< 0.1%
77.001
 
< 0.1%
43.601
 
< 0.1%
17.851
 
< 0.1%
Other values (183)183
 
0.1%

Most occurring characters

ValueCountFrequency (%)
0357960
42.8%
238936
28.6%
.119468
 
14.3%
119468
 
14.3%
1116
 
< 0.1%
294
 
< 0.1%
586
 
< 0.1%
481
 
< 0.1%
775
 
< 0.1%
374
 
< 0.1%
Other values (3)206
 
< 0.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number358692
42.9%
Space Separator238936
28.6%
Other Punctuation119468
 
14.3%
Currency Symbol119468
 
14.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0357960
99.8%
1116
 
< 0.1%
294
 
< 0.1%
586
 
< 0.1%
481
 
< 0.1%
775
 
< 0.1%
374
 
< 0.1%
674
 
< 0.1%
967
 
< 0.1%
865
 
< 0.1%
Space Separator
ValueCountFrequency (%)
238936
100.0%
Other Punctuation
ValueCountFrequency (%)
.119468
100.0%
Currency Symbol
ValueCountFrequency (%)
119468
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common836564
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0357960
42.8%
238936
28.6%
.119468
 
14.3%
119468
 
14.3%
1116
 
< 0.1%
294
 
< 0.1%
586
 
< 0.1%
481
 
< 0.1%
775
 
< 0.1%
374
 
< 0.1%
Other values (3)206
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII717096
85.7%
Currency Symbols119468
 
14.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0357960
49.9%
238936
33.3%
.119468
 
16.7%
1116
 
< 0.1%
294
 
< 0.1%
586
 
< 0.1%
481
 
< 0.1%
775
 
< 0.1%
374
 
< 0.1%
674
 
< 0.1%
Other values (2)132
 
< 0.1%
Currency Symbols
ValueCountFrequency (%)
119468
100.0%

Tipo de Componente
Categorical

HIGH CARDINALITY

Distinct139
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
CALACS - Calefacción y ACS - Acumulador ACS
13342 
CLI - Climatización - Fancoil
12415 
CALACS - Calefacción y ACS - Bomba
11699 
ELEC - Electricidad - BT - Cuadro Electrico
8557 
MTOGN - Mantenimiento General - Edificios
 
6422
Other values (134)
67033 

Length

Max length75
Median length64
Mean length37.39443198
Min length3

Characters and Unicode

Total characters4467438
Distinct characters61
Distinct categories9 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique5 ?
Unique (%)< 0.1%

Sample

1st rowELEC - Electricidad - BT - Cuadro Electrico
2nd rowELEC - Electricidad - BT - Cuadro Electrico
3rd rowINTS - Int Solar - Vaso Expansión
4th rowELEC - Electricidad - BT - Cuadro Electrico
5th rowCALACS - Calefacción y ACS - Caldera Gas 70<P<1000 kW

Common Values

ValueCountFrequency (%)
CALACS - Calefacción y ACS - Acumulador ACS13342
 
11.2%
CLI - Climatización - Fancoil12415
 
10.4%
CALACS - Calefacción y ACS - Bomba11699
 
9.8%
ELEC - Electricidad - BT - Cuadro Electrico8557
 
7.2%
MTOGN - Mantenimiento General - Edificios6422
 
5.4%
CLI - Climatización - Bomba5375
 
4.5%
MTOGN - Mantenimiento General - Visita5068
 
4.2%
CLI - Climatización - UTA - UTA sin Humectación4735
 
4.0%
PCI - Extintores4315
 
3.6%
CLI - Climatización - Unidad Interior4181
 
3.5%
Other values (129)43359
36.3%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
265170
32.1%
acs47749
 
5.8%
cli34595
 
4.2%
climatización34595
 
4.2%
y34265
 
4.2%
calacs34093
 
4.1%
calefacción34093
 
4.1%
bomba23420
 
2.8%
acumulador13656
 
1.7%
fancoil12415
 
1.5%
Other values (175)291496
35.3%

Most occurring characters

ValueCountFrequency (%)
706081
15.8%
a334798
 
7.5%
i317446
 
7.1%
-263212
 
5.9%
C262060
 
5.9%
c213004
 
4.8%
n196761
 
4.4%
o165560
 
3.7%
A162518
 
3.6%
e156237
 
3.5%
Other values (51)1689761
37.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter2414812
54.1%
Uppercase Letter1037711
23.2%
Space Separator706081
 
15.8%
Dash Punctuation263212
 
5.9%
Decimal Number29416
 
0.7%
Math Symbol11694
 
0.3%
Open Punctuation2253
 
0.1%
Close Punctuation2253
 
0.1%
Other Punctuation6
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a334798
13.9%
i317446
13.1%
c213004
8.8%
n196761
 
8.1%
o165560
 
6.9%
e156237
 
6.5%
r149870
 
6.2%
l145967
 
6.0%
t130910
 
5.4%
m101112
 
4.2%
Other values (19)503147
20.8%
Uppercase Letter
ValueCountFrequency (%)
C262060
25.3%
A162518
15.7%
S95801
 
9.2%
L79316
 
7.6%
E72944
 
7.0%
I70904
 
6.8%
G51386
 
5.0%
F39757
 
3.8%
T39673
 
3.8%
B34049
 
3.3%
Other values (11)129303
12.5%
Decimal Number
ValueCountFrequency (%)
019616
66.7%
14908
 
16.7%
74892
 
16.6%
Math Symbol
ValueCountFrequency (%)
<9760
83.5%
+1894
 
16.2%
>40
 
0.3%
Space Separator
ValueCountFrequency (%)
706081
100.0%
Dash Punctuation
ValueCountFrequency (%)
-263212
100.0%
Open Punctuation
ValueCountFrequency (%)
(2253
100.0%
Close Punctuation
ValueCountFrequency (%)
)2253
100.0%
Other Punctuation
ValueCountFrequency (%)
,6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin3452523
77.3%
Common1014915
 
22.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
a334798
 
9.7%
i317446
 
9.2%
C262060
 
7.6%
c213004
 
6.2%
n196761
 
5.7%
o165560
 
4.8%
A162518
 
4.7%
e156237
 
4.5%
r149870
 
4.3%
l145967
 
4.2%
Other values (40)1348302
39.1%
Common
ValueCountFrequency (%)
706081
69.6%
-263212
 
25.9%
019616
 
1.9%
<9760
 
1.0%
14908
 
0.5%
74892
 
0.5%
(2253
 
0.2%
)2253
 
0.2%
+1894
 
0.2%
>40
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII4370057
97.8%
None97381
 
2.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
706081
16.2%
a334798
 
7.7%
i317446
 
7.3%
-263212
 
6.0%
C262060
 
6.0%
c213004
 
4.9%
n196761
 
4.5%
o165560
 
3.8%
A162518
 
3.7%
e156237
 
3.6%
Other values (47)1592380
36.4%
None
ValueCountFrequency (%)
ó81468
83.7%
í7430
 
7.6%
é6678
 
6.9%
á1805
 
1.9%

Matrícula
Categorical

HIGH CORRELATION

Distinct30
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
119206 
NUMERO 2
 
18
NUMERO 3
 
15
GCGAS70-001
 
13
BMETERS
 
12
Other values (25)
 
204

Length

Max length11
Median length1
Mean length1.01647303
Min length1

Characters and Unicode

Total characters121436
Distinct characters29
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
119206
99.8%
NUMERO 218
 
< 0.1%
NUMERO 315
 
< 0.1%
GCGAS70-00113
 
< 0.1%
BMETERS12
 
< 0.1%
BOM00-00310
 
< 0.1%
GP000-00110
 
< 0.1%
ACU00-00210
 
< 0.1%
ACU00-00310
 
< 0.1%
BOM00-00210
 
< 0.1%
Other values (20)154
 
0.1%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
numero33
 
11.0%
218
 
6.0%
315
 
5.0%
gcgas70-00113
 
4.3%
bmeters12
 
4.0%
acu00-00110
 
3.3%
frio10
 
3.3%
bom00-00410
 
3.3%
bom00-00510
 
3.3%
bom00-00110
 
3.3%
Other values (21)159
53.0%

Most occurring characters

ValueCountFrequency (%)
119244
98.2%
0664
 
0.5%
-166
 
0.1%
O132
 
0.1%
M111
 
0.1%
A102
 
0.1%
E100
 
0.1%
C91
 
0.1%
R87
 
0.1%
186
 
0.1%
Other values (19)653
 
0.5%

Most occurring categories

ValueCountFrequency (%)
Space Separator119244
98.2%
Uppercase Letter1138
 
0.9%
Decimal Number888
 
0.7%
Dash Punctuation166
 
0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
O132
11.6%
M111
9.8%
A102
 
9.0%
E100
 
8.8%
C91
 
8.0%
R87
 
7.6%
U84
 
7.4%
B67
 
5.9%
S55
 
4.8%
I49
 
4.3%
Other values (10)260
22.8%
Decimal Number
ValueCountFrequency (%)
0664
74.8%
186
 
9.7%
249
 
5.5%
347
 
5.3%
419
 
2.1%
713
 
1.5%
510
 
1.1%
Space Separator
ValueCountFrequency (%)
119244
100.0%
Dash Punctuation
ValueCountFrequency (%)
-166
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common120298
99.1%
Latin1138
 
0.9%

Most frequent character per script

Latin
ValueCountFrequency (%)
O132
11.6%
M111
9.8%
A102
 
9.0%
E100
 
8.8%
C91
 
8.0%
R87
 
7.6%
U84
 
7.4%
B67
 
5.9%
S55
 
4.8%
I49
 
4.3%
Other values (10)260
22.8%
Common
ValueCountFrequency (%)
119244
99.1%
0664
 
0.6%
-166
 
0.1%
186
 
0.1%
249
 
< 0.1%
347
 
< 0.1%
419
 
< 0.1%
713
 
< 0.1%
510
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII121436
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
119244
98.2%
0664
 
0.5%
-166
 
0.1%
O132
 
0.1%
M111
 
0.1%
A102
 
0.1%
E100
 
0.1%
C91
 
0.1%
R87
 
0.1%
186
 
0.1%
Other values (19)653
 
0.5%

Núm. Serie
Categorical

HIGH CARDINALITY

Distinct1463
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
106181 
18 T 1217 90436
 
612
19434
 
298
4607
 
297
2777
 
297
Other values (1458)
11783 

Length

Max length29
Median length1
Mean length1.765845247
Min length1

Characters and Unicode

Total characters210962
Distinct characters50
Distinct categories9 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique144 ?
Unique (%)0.1%

Sample

1st row
2nd row
3rd row
4th row
5th row1015809208860

Common Values

ValueCountFrequency (%)
106181
88.9%
18 T 1217 90436612
 
0.5%
19434298
 
0.2%
4607297
 
0.2%
2777297
 
0.2%
3434297
 
0.2%
19435297
 
0.2%
4527297
 
0.2%
19336297
 
0.2%
2776297
 
0.2%
Other values (1453)10298
 
8.6%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
18612
 
3.8%
t612
 
3.8%
1217612
 
3.8%
90436612
 
3.8%
19434298
 
1.9%
4607297
 
1.9%
2777297
 
1.9%
3434297
 
1.9%
19435297
 
1.9%
4527297
 
1.9%
Other values (1498)11765
73.5%

Most occurring characters

ValueCountFrequency (%)
108898
51.6%
017592
 
8.3%
113879
 
6.6%
29568
 
4.5%
39461
 
4.5%
48520
 
4.0%
78407
 
4.0%
66559
 
3.1%
56097
 
2.9%
95874
 
2.8%
Other values (40)16107
 
7.6%

Most occurring categories

ValueCountFrequency (%)
Space Separator108898
51.6%
Decimal Number91033
43.2%
Uppercase Letter8360
 
4.0%
Dash Punctuation1490
 
0.7%
Other Punctuation968
 
0.5%
Other Letter113
 
0.1%
Lowercase Letter80
 
< 0.1%
Open Punctuation10
 
< 0.1%
Close Punctuation10
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
T1051
12.6%
L964
 
11.5%
E754
 
9.0%
A612
 
7.3%
C538
 
6.4%
M532
 
6.4%
P417
 
5.0%
B330
 
3.9%
W316
 
3.8%
F315
 
3.8%
Other values (16)2531
30.3%
Decimal Number
ValueCountFrequency (%)
017592
19.3%
113879
15.2%
29568
10.5%
39461
10.4%
48520
9.4%
78407
9.2%
66559
 
7.2%
56097
 
6.7%
95874
 
6.5%
85076
 
5.6%
Lowercase Letter
ValueCountFrequency (%)
w37
46.2%
b13
 
16.2%
l13
 
16.2%
e13
 
16.2%
j2
 
2.5%
o2
 
2.5%
Other Punctuation
ValueCountFrequency (%)
/780
80.6%
.122
 
12.6%
:66
 
6.8%
Space Separator
ValueCountFrequency (%)
108898
100.0%
Dash Punctuation
ValueCountFrequency (%)
-1490
100.0%
Other Letter
ValueCountFrequency (%)
º113
100.0%
Open Punctuation
ValueCountFrequency (%)
(10
100.0%
Close Punctuation
ValueCountFrequency (%)
)10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common202409
95.9%
Latin8553
 
4.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
T1051
 
12.3%
L964
 
11.3%
E754
 
8.8%
A612
 
7.2%
C538
 
6.3%
M532
 
6.2%
P417
 
4.9%
B330
 
3.9%
W316
 
3.7%
F315
 
3.7%
Other values (23)2724
31.8%
Common
ValueCountFrequency (%)
108898
53.8%
017592
 
8.7%
113879
 
6.9%
29568
 
4.7%
39461
 
4.7%
48520
 
4.2%
78407
 
4.2%
66559
 
3.2%
56097
 
3.0%
95874
 
2.9%
Other values (7)7554
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII210849
99.9%
None113
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
108898
51.6%
017592
 
8.3%
113879
 
6.6%
29568
 
4.5%
39461
 
4.5%
48520
 
4.0%
78407
 
4.0%
66559
 
3.1%
56097
 
2.9%
95874
 
2.8%
Other values (39)15994
 
7.6%
None
ValueCountFrequency (%)
º113
100.0%

Servicio
Categorical

HIGH CORRELATION

Distinct21
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
31834 
Climatización
28189 
Calefacción y ACS
25355 
Electricidad
9055 
Frío
5523 
Other values (16)
19512 

Length

Max length24
Median length17
Mean length8.94492249
Min length1

Characters and Unicode

Total characters1068632
Distinct characters31
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowElectricidad
2nd rowElectricidad
3rd row
4th rowElectricidad
5th rowCalefacción y ACS

Common Values

ValueCountFrequency (%)
31834
26.6%
Climatización28189
23.6%
Calefacción y ACS25355
21.2%
Electricidad9055
 
7.6%
Frío5523
 
4.6%
PCI5414
 
4.5%
ACS4111
 
3.4%
AFS4045
 
3.4%
Solar1154
 
1.0%
Ventilación1001
 
0.8%
Other values (11)3787
 
3.2%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
acs29466
21.1%
climatización28189
20.1%
calefacción26316
18.8%
y25355
18.1%
electricidad9055
 
6.5%
frío5523
 
3.9%
pci5414
 
3.9%
afs4045
 
2.9%
solar1154
 
0.8%
ventilación1001
 
0.7%
Other values (13)4454
 
3.2%

Most occurring characters

ValueCountFrequency (%)
i135053
12.6%
a122765
11.5%
c103531
 
9.7%
C90729
 
8.5%
84172
 
7.9%
l66758
 
6.2%
n61840
 
5.8%
ó56812
 
5.3%
t39651
 
3.7%
e39269
 
3.7%
Other values (21)268052
25.1%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter791993
74.1%
Uppercase Letter192467
 
18.0%
Space Separator84172
 
7.9%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
i135053
17.1%
a122765
15.5%
c103531
13.1%
l66758
8.4%
n61840
7.8%
ó56812
7.2%
t39651
 
5.0%
e39269
 
5.0%
m28923
 
3.7%
z28189
 
3.6%
Other values (10)109202
13.8%
Uppercase Letter
ValueCountFrequency (%)
C90729
47.1%
S34680
 
18.0%
A33578
 
17.4%
F9661
 
5.0%
E9055
 
4.7%
P6080
 
3.2%
I6068
 
3.2%
V1001
 
0.5%
M974
 
0.5%
G641
 
0.3%
Space Separator
ValueCountFrequency (%)
84172
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin984460
92.1%
Common84172
 
7.9%

Most frequent character per script

Latin
ValueCountFrequency (%)
i135053
13.7%
a122765
12.5%
c103531
10.5%
C90729
 
9.2%
l66758
 
6.8%
n61840
 
6.3%
ó56812
 
5.8%
t39651
 
4.0%
e39269
 
4.0%
S34680
 
3.5%
Other values (20)233372
23.7%
Common
ValueCountFrequency (%)
84172
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII1006166
94.2%
None62466
 
5.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
i135053
13.4%
a122765
12.2%
c103531
10.3%
C90729
 
9.0%
84172
 
8.4%
l66758
 
6.6%
n61840
 
6.1%
t39651
 
3.9%
e39269
 
3.9%
S34680
 
3.4%
Other values (19)227718
22.6%
None
ValueCountFrequency (%)
ó56812
90.9%
í5654
 
9.1%

Centro de coste
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
119468 

Length

Max length1
Median length1
Mean length1
Min length1

Characters and Unicode

Total characters119468
Distinct characters1
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
119468
100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

ValueCountFrequency (%)
No values found.

Most occurring characters

ValueCountFrequency (%)
119468
100.0%

Most occurring categories

ValueCountFrequency (%)
Space Separator119468
100.0%

Most frequent character per category

Space Separator
ValueCountFrequency (%)
119468
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common119468
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
119468
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII119468
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
119468
100.0%

Operario PDA
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct76
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
35035 
DANIEL LUQUE MARTÍNEZ
 
5186
DANIEL GUIJARRO GALINDO
 
4591
MIGUEL ÁNGEL FERNÁNDEZ GUIJARRO
 
3899
SAID ELGANDOUZ FARES
 
3861
Other values (71)
66896 

Length

Max length36
Median length29
Mean length15.72073693
Min length1

Characters and Unicode

Total characters1878125
Distinct characters41
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique4 ?
Unique (%)< 0.1%

Sample

1st row
2nd row
3rd rowDANIEL LUQUE MARTÍNEZ
4th rowFELIX GARCÍA
5th rowABEL CARVAJAL CABAS

Common Values

ValueCountFrequency (%)
35035
29.3%
DANIEL LUQUE MARTÍNEZ5186
 
4.3%
DANIEL GUIJARRO GALINDO4591
 
3.8%
MIGUEL ÁNGEL FERNÁNDEZ GUIJARRO3899
 
3.3%
SAID ELGANDOUZ FARES3861
 
3.2%
DIEGO HERNÁNDEZ GARCÍA3801
 
3.2%
DAVID POZO RODRÍGUEZ3666
 
3.1%
ABEL CARVAJAL CABAS3520
 
2.9%
LAUREANO VIEJO PÉREZ3119
 
2.6%
ISRAEL VILLALBA DURÁN2944
 
2.5%
Other values (66)49846
41.7%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
javier11317
 
4.2%
daniel9777
 
3.7%
guijarro8490
 
3.2%
garcía7118
 
2.7%
martínez6558
 
2.5%
juan6242
 
2.3%
david5621
 
2.1%
luque5186
 
1.9%
galindo4591
 
1.7%
hernández4260
 
1.6%
Other values (172)198269
74.1%

Most occurring characters

ValueCountFrequency (%)
220373
11.7%
A219108
11.7%
E171443
 
9.1%
R158780
 
8.5%
O114324
 
6.1%
N113030
 
6.0%
L106763
 
5.7%
I105503
 
5.6%
D78817
 
4.2%
U63977
 
3.4%
Other values (31)526007
28.0%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter1657730
88.3%
Space Separator220374
 
11.7%
Lowercase Letter21
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A219108
13.2%
E171443
 
10.3%
R158780
 
9.6%
O114324
 
6.9%
N113030
 
6.8%
L106763
 
6.4%
I105503
 
6.4%
D78817
 
4.8%
U63977
 
3.9%
G63502
 
3.8%
Other values (20)462483
27.9%
Lowercase Letter
ValueCountFrequency (%)
n4
19.0%
e4
19.0%
u3
14.3%
a3
14.3%
l2
9.5%
b2
9.5%
r1
 
4.8%
i1
 
4.8%
t1
 
4.8%
Space Separator
ValueCountFrequency (%)
220373
> 99.9%
 1
 
< 0.1%

Most occurring scripts

ValueCountFrequency (%)
Latin1657751
88.3%
Common220374
 
11.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
A219108
13.2%
E171443
 
10.3%
R158780
 
9.6%
O114324
 
6.9%
N113030
 
6.8%
L106763
 
6.4%
I105503
 
6.4%
D78817
 
4.8%
U63977
 
3.9%
G63502
 
3.8%
Other values (29)462504
27.9%
Common
ValueCountFrequency (%)
220373
> 99.9%
 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII1818790
96.8%
None59335
 
3.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
220373
12.1%
A219108
12.0%
E171443
 
9.4%
R158780
 
8.7%
O114324
 
6.3%
N113030
 
6.2%
L106763
 
5.9%
I105503
 
5.8%
D78817
 
4.3%
U63977
 
3.5%
Other values (25)466672
25.7%
None
ValueCountFrequency (%)
Á24222
40.8%
Í20313
34.2%
Ó6546
 
11.0%
É5477
 
9.2%
Ñ2776
 
4.7%
 1
 
< 0.1%

tiempo_parada_horas
Categorical

HIGH CORRELATION

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
00
119450 
08
 
10
01
 
8

Length

Max length2
Median length2
Mean length2
Min length2

Characters and Unicode

Total characters238936
Distinct characters3
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row00
2nd row00
3rd row00
4th row00
5th row00

Common Values

ValueCountFrequency (%)
00119450
> 99.9%
0810
 
< 0.1%
018
 
< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

ValueCountFrequency (%)
00119450
> 99.9%
0810
 
< 0.1%
018
 
< 0.1%

Most occurring characters

ValueCountFrequency (%)
0238918
> 99.9%
810
 
< 0.1%
18
 
< 0.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number238936
100.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0238918
> 99.9%
810
 
< 0.1%
18
 
< 0.1%

Most occurring scripts

ValueCountFrequency (%)
Common238936
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0238918
> 99.9%
810
 
< 0.1%
18
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII238936
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0238918
> 99.9%
810
 
< 0.1%
18
 
< 0.1%

tiempo_parada_minutos
Real number (ℝ≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct6
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.00303010011
Minimum0
Maximum45
Zeros119453
Zeros (%)> 99.9%
Negative0
Negative (%)0.0%
Memory size933.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum45
Range45
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.3055139477
Coefficient of variation (CV)100.8263544
Kurtosis11725.80367
Mean0.00303010011
Median Absolute Deviation (MAD)0
Skewness106.3054263
Sum362
Variance0.09333877224
MonotonicityNot monotonic
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
0119453
> 99.9%
3010
 
< 0.1%
12
 
< 0.1%
101
 
< 0.1%
51
 
< 0.1%
451
 
< 0.1%
ValueCountFrequency (%)
0119453
> 99.9%
12
 
< 0.1%
51
 
< 0.1%
101
 
< 0.1%
3010
 
< 0.1%
451
 
< 0.1%
ValueCountFrequency (%)
451
 
< 0.1%
3010
 
< 0.1%
101
 
< 0.1%
51
 
< 0.1%
12
 
< 0.1%
0119453
> 99.9%

tiempo_estimado_horas
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct27
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.31435196
Minimum0
Maximum74
Zeros99986
Zeros (%)83.7%
Negative0
Negative (%)0.0%
Memory size933.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile9
Maximum74
Range74
Interquartile range (IQR)0

Descriptive statistics

Standard deviation5.900901706
Coefficient of variation (CV)4.48959022
Kurtosis80.73138989
Mean1.31435196
Median Absolute Deviation (MAD)0
Skewness8.000319879
Sum157023
Variance34.82064095
MonotonicityNot monotonic
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
099986
83.7%
16626
 
5.5%
22971
 
2.5%
31187
 
1.0%
91087
 
0.9%
41053
 
0.9%
11896
 
0.7%
27872
 
0.7%
5808
 
0.7%
16447
 
0.4%
Other values (17)3535
 
3.0%
ValueCountFrequency (%)
099986
83.7%
16626
 
5.5%
22971
 
2.5%
31187
 
1.0%
41053
 
0.9%
5808
 
0.7%
6417
 
0.3%
7180
 
0.2%
8196
 
0.2%
91087
 
0.9%
ValueCountFrequency (%)
74332
 
0.3%
6974
 
0.1%
41142
 
0.1%
36146
 
0.1%
35142
 
0.1%
27872
0.7%
26106
 
0.1%
21336
 
0.3%
2020
 
< 0.1%
18442
0.4%

tiempo_estimado_minutos
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct34
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.6055178
Minimum0
Maximum58
Zeros38368
Zeros (%)32.1%
Negative0
Negative (%)0.0%
Memory size933.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median5
Q315
95-th percentile40
Maximum58
Range58
Interquartile range (IQR)15

Descriptive statistics

Standard deviation13.23289405
Coefficient of variation (CV)1.140224356
Kurtosis1.022509285
Mean11.6055178
Median Absolute Deviation (MAD)5
Skewness1.272342705
Sum1386488
Variance175.109485
MonotonicityNot monotonic
Histogram with fixed size bins (bins=34)
ValueCountFrequency (%)
038368
32.1%
1520112
16.8%
515723
13.2%
1012001
 
10.0%
3011871
 
9.9%
253305
 
2.8%
203275
 
2.7%
452768
 
2.3%
12629
 
2.2%
22152
 
1.8%
Other values (24)7264
 
6.1%
ValueCountFrequency (%)
038368
32.1%
12629
 
2.2%
22152
 
1.8%
3300
 
0.3%
4652
 
0.5%
515723
13.2%
687
 
0.1%
791
 
0.1%
8588
 
0.5%
9154
 
0.1%
ValueCountFrequency (%)
5859
 
< 0.1%
551150
1.0%
53118
 
0.1%
501036
 
0.9%
48576
 
0.5%
452768
2.3%
401136
1.0%
3849
 
< 0.1%
36192
 
0.2%
35719
 
0.6%

tiempo_mo_horas
Real number (ℝ≥0)

ZEROS

Distinct67
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.3582465597
Minimum0
Maximum95
Zeros105592
Zeros (%)88.4%
Negative0
Negative (%)0.0%
Memory size933.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile2
Maximum95
Range95
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.934920138
Coefficient of variation (CV)5.401085049
Kurtosis484.6365878
Mean0.3582465597
Median Absolute Deviation (MAD)0
Skewness17.09973655
Sum42799
Variance3.743915939
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0105592
88.4%
16204
 
5.2%
23075
 
2.6%
31594
 
1.3%
4840
 
0.7%
5541
 
0.5%
6346
 
0.3%
8295
 
0.2%
7203
 
0.2%
9136
 
0.1%
Other values (57)642
 
0.5%
ValueCountFrequency (%)
0105592
88.4%
16204
 
5.2%
23075
 
2.6%
31594
 
1.3%
4840
 
0.7%
5541
 
0.5%
6346
 
0.3%
7203
 
0.2%
8295
 
0.2%
9136
 
0.1%
ValueCountFrequency (%)
951
< 0.1%
901
< 0.1%
891
< 0.1%
841
< 0.1%
802
< 0.1%
772
< 0.1%
761
< 0.1%
721
< 0.1%
681
< 0.1%
671
< 0.1%

tiempo_mo_minutos
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct60
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.190343858
Minimum0
Maximum59
Zeros69510
Zeros (%)58.2%
Negative0
Negative (%)0.0%
Memory size933.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q35
95-th percentile30
Maximum59
Range59
Interquartile range (IQR)5

Descriptive statistics

Standard deviation10.45037187
Coefficient of variation (CV)2.013425729
Kurtosis5.418848199
Mean5.190343858
Median Absolute Deviation (MAD)0
Skewness2.423329879
Sum620080
Variance109.2102721
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
069510
58.2%
110850
 
9.1%
305657
 
4.7%
54020
 
3.4%
23680
 
3.1%
153021
 
2.5%
32952
 
2.5%
62264
 
1.9%
101626
 
1.4%
41523
 
1.3%
Other values (50)14365
 
12.0%
ValueCountFrequency (%)
069510
58.2%
110850
 
9.1%
23680
 
3.1%
32952
 
2.5%
41523
 
1.3%
54020
 
3.4%
62264
 
1.9%
7915
 
0.8%
81273
 
1.1%
91504
 
1.3%
ValueCountFrequency (%)
5932
 
< 0.1%
5826
 
< 0.1%
5730
 
< 0.1%
5631
 
< 0.1%
5564
 
0.1%
5479
0.1%
5356
 
< 0.1%
5282
0.1%
5145
 
< 0.1%
50189
0.2%

Datetime_aviso
Date

MISSING

Distinct885
Distinct (%)99.4%
Missing118578
Missing (%)99.3%
Memory size933.5 KiB
Minimum2021-01-09 11:52:00
Maximum2022-12-08 12:05:00
Histogram with fixed size bins (bins=50)
Distinct8839
Distinct (%)7.4%
Missing0
Missing (%)0.0%
Memory size933.5 KiB
Minimum2020-01-09 00:00:00
Maximum2022-12-31 00:00:00
Histogram with fixed size bins (bins=50)

Datetime_inicio
Date

MISSING

Distinct6288
Distinct (%)5.5%
Missing4188
Missing (%)3.5%
Memory size933.5 KiB
Minimum2020-01-09 00:00:00
Maximum2022-12-31 00:00:00
Histogram with fixed size bins (bins=50)

Datetime_fin
Date

MISSING

Distinct10569
Distinct (%)19.4%
Missing65019
Missing (%)54.4%
Memory size933.5 KiB
Minimum2020-08-07 00:00:00
Maximum2022-12-08 18:00:00
Histogram with fixed size bins (bins=50)
Distinct24884
Distinct (%)34.0%
Missing46278
Missing (%)38.7%
Memory size933.5 KiB
Minimum2021-01-12 13:51:00
Maximum2022-12-08 18:27:00
Histogram with fixed size bins (bins=50)

Interactions

Correlations

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

Sample

First rows

O.T.Núm. AvisoTipoEstadoDescripciónDNIDesc. EquipoGenerador OTGenerador AvisoSolicitanteObservaciones AvisoFecha Prev. Realiz.Descripción de los Trabajos RealizadosObservacionesCentro de trabajoÁrbol departamentalTipo IntervenciónTipo de IncidenciaPrioridadCoste MOICoste MOECoste MaterialTipo de ComponenteMatrículaNúm. SerieServicioCentro de costeOperario PDAtiempo_parada_horastiempo_parada_minutostiempo_estimado_horastiempo_estimado_minutostiempo_mo_horastiempo_mo_minutosDatetime_avisoDatetime_solicitudDatetime_inicioDatetime_finDatetime_realización
0105738NaNPreventivoRealizadoCuadro Eléctrico - Gama MensualEDF-V34-CE000-004CUADRO ELÉCTRICO - S2 - EXTRACCIÓN 12020-01-11REX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34EDIFICIO - VELAZQUEZ 34Preventivo - Electricidad - BTBaja0.00 €0.00 €0.00 €ELEC - Electricidad - BT - Cuadro ElectricoElectricidad000000100000NaT2020-01-112020-01-11 00:00:00NaT2022-01-31 12:53:00
1105738NaNPreventivoRealizadoCuadro Eléctrico - Gama MensualEDF-V34-CE000-006CUADRO ELÉCTRICO - S1 - GARAJE 12020-01-11REX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34EDIFICIO - VELAZQUEZ 34Preventivo - Electricidad - BTBaja0.00 €0.00 €0.00 €ELEC - Electricidad - BT - Cuadro ElectricoElectricidad000000100000NaT2020-01-112020-01-11 00:00:00NaT2022-01-31 12:53:00
2124981NaNPreventivoRealizadoVaso Expansión - Gama MensualSAT-R03-VPPE-VEXP0-004VASO DE EXPANSIÓN - SOLAR - VE04 (400L)2021-01-03VP HOTELES - SAT 2 - VP PLAZA DE ESPAÑA DESIGNSAT - RUTA 03 - VP PLAZA DE ESPAÑA DESIGNPreventivo - AFSBaja0.00 €0.00 €0.00 €INTS - Int Solar - Vaso ExpansiónDANIEL LUQUE MARTÍNEZ000000080000NaT2021-01-032021-01-03 00:00:002022-04-25 00:01:002022-04-25 08:38:00
3133466NaNPreventivoRealizadoCuadro Eléctrico - Gama MensualEDF-OS11-P05-TERZ-CE000-023CUADRO ELÉCTRICO - CE-ASC.A12021-01-04TORRE RIOJA MADRID S.A. - SAT 1 - OSIRIS 11EDIFICIO - OSIRIS 11 (ROCHE) - PLANTA QUINTA - TERRAZAPreventivo - Electricidad - BTBaja0.00 €0.00 €0.00 €ELEC - Electricidad - BT - Cuadro ElectricoElectricidadFELIX GARCÍA000009200009NaT2021-01-042021-09-04 09:00:002021-09-04 17:30:002022-01-25 08:24:00
4139777NaNPreventivoRealizadoCaldera Gas - Gama TrimestralSAT-R09-SANM-SANMAS-GCA70-004CALDERA ACS - 65 kW2021-01-05SANITAS MAYORES, S.L. - SAT 2 - SANITAS ARTURO SORIASAT - RUTA 09 - SANITAS MAYORES, S.L. - SANITAS ARTURO SORIAPreventivo - Calefacción y ACSMedia0.00 €0.00 €0.00 €CALACS - Calefacción y ACS - Caldera Gas 70<P<1000 kW1015809208860Calefacción y ACSABEL CARVAJAL CABAS000000100002NaT2021-01-052021-01-05 00:00:002021-03-05 00:02:002022-11-02 11:13:00
5148670NaNPreventivoRealizadoCuadro Eléctrico - Gama MensualEDF-V34-CE000-007CUADRO ELÉCTRICO - S1 - GARAJE 22021-01-07REX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34EDIFICIO - VELAZQUEZ 34Preventivo - Electricidad - BTBaja0.00 €0.00 €0.00 €ELEC - Electricidad - BT - Cuadro ElectricoElectricidad000000100000NaT2021-01-072021-01-07 00:00:00NaT2022-01-31 12:53:00
6153587NaNPreventivoRealizadoCuadro Eléctrico - Gama MensualEDF-OS11-S04-PCIB-CE000-054CUADRO ELÉCTRICO - CP-INC22021-01-08TORRE RIOJA MADRID S.A. - SAT 1 - OSIRIS 11EDIFICIO - OSIRIS 11 (ROCHE) - SOTANO 4 - SALA PCI B (PLAZA 08) (HIDRANTES)Preventivo - Electricidad - BTBaja0.00 €0.00 €0.00 €ELEC - Electricidad - BT - Cuadro ElectricoElectricidadFELIX GARCÍA000009200009NaT2021-01-082021-09-09 09:00:002021-09-09 17:30:002022-01-25 08:30:00
7153587NaNPreventivoRealizadoCuadro Eléctrico - Gama MensualEDF-OS11-P06-INT-CE000-029CUADRO ELÉCTRICO - CE-INS2021-01-08TORRE RIOJA MADRID S.A. - SAT 1 - OSIRIS 11EDIFICIO - OSIRIS 11 (ROCHE) - AZOTEA - PLANTA INSTALACIONESPreventivo - Electricidad - BTBaja0.00 €0.00 €0.00 €ELEC - Electricidad - BT - Cuadro ElectricoElectricidadFELIX GARCÍA000009200009NaT2021-01-082021-09-09 09:00:002021-09-09 17:30:002022-01-25 08:30:00
8148670NaNPreventivoRealizadoCuadro Eléctrico - Gama MensualEDF-V34-CE000-014CUADRO ELÉCTRICO - P1.OF12021-01-07REX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34EDIFICIO - VELAZQUEZ 34Preventivo - Electricidad - BTBaja0.00 €0.00 €0.00 €ELEC - Electricidad - BT - Cuadro ElectricoElectricidad000000100000NaT2021-01-072021-01-07 00:00:00NaT2022-01-31 12:53:00
9148670NaNPreventivoRealizadoCuadro Eléctrico - Gama MensualEDF-V34-CE000-016CUADRO ELÉCTRICO - P2.OF22021-01-07REX SPAIN ZDHL S.L. - SAT 2 - VELAZQUEZ 34EDIFICIO - VELAZQUEZ 34Preventivo - Electricidad - BTBaja0.00 €0.00 €0.00 €ELEC - Electricidad - BT - Cuadro ElectricoElectricidad000000100000NaT2021-01-072021-01-07 00:00:00NaT2022-01-31 12:53:00

Last rows

O.T.Núm. AvisoTipoEstadoDescripciónDNIDesc. EquipoGenerador OTGenerador AvisoSolicitanteObservaciones AvisoFecha Prev. Realiz.Descripción de los Trabajos RealizadosObservacionesCentro de trabajoÁrbol departamentalTipo IntervenciónTipo de IncidenciaPrioridadCoste MOICoste MOECoste MaterialTipo de ComponenteMatrículaNúm. SerieServicioCentro de costeOperario PDAtiempo_parada_horastiempo_parada_minutostiempo_estimado_horastiempo_estimado_minutostiempo_mo_horastiempo_mo_minutosDatetime_avisoDatetime_solicitudDatetime_inicioDatetime_finDatetime_realización
119458214161NaNCorrectivoAbiertoAviso en QBE, problemas frigorificoEDF-MM-C31-EDF-MTOGNMANTENIMENTO GENERALMARÍA MENDOZA ARÉVALO2022-07-06MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - EDIFICIO PIRAMIDE (CASTELLANA 31)EDIFICIO - MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - CASTELLANA 31 (EDF PIRÁMIDE) - EDIFICIOMtto General0.00 €0.00 €0.00 €MTOGN - Mantenimiento General - Edificios000000000000NaT2022-07-06 13:19:00NaTNaTNaT
119459214150NaNCorrectivoRealizadoSUST. VENTILADOR CUARTO FRÍO COCINASAT-R09-HVSH.C-MTOGNMANTENIMIENTO GENERALJUAN VAZQUEZ2022-07-06Se realiza sustitución del motor de uno de los dos ventiladores del cuarto frío.VINCCI HOTELES, S.A. - SAT 2 - VINCCI SOHO COCINASSAT - RUTA 09 - VINCCI SOHO COCINASAviso - TF0.00 €0.00 €104.19 €MTOGN - Mantenimiento General - VisitaABEL CARVAJAL CABAS000000000400NaT2022-07-06 10:35:002022-07-06 00:00:002022-07-06 04:00:002022-07-06 10:20:00
119460214151NaNCorrectivoRealizadoOficinaSAT-R09-SIM-MTOGNMANTENIMIENTO GENERALRAMÓN DE CASTRO GAVILÁN2000-01-01SIMALGA, S.L. - SIN SAT - SIMALGA OFICINASAT - RUTA 09 - SIMALGA, S.L.0.00 €0.00 €0.00 €MTOGN - Mantenimiento General - Visita000000000745NaT2022-07-06 10:36:002022-03-06 08:00:002022-06-24 00:45:002022-06-30 13:14:00
119461214153NaNCorrectivoRealizadoFuga del retorno de ACS: están mojando las bombas de retorno de solar. Comprobar fuga y corroborar que el solar funciona.SAT-R02-CPPN-MTOGNMANTENIMIENTO GENERALJUAN VAZQUEZ2022-07-06Se acomete reparación y saneamiento de un tramo de tubería de cobre de 35 mm, con fuga de agua en circuito general de retorno de agua caliente sanitaria. Se ajustan presiones de los circuitos y se comprueba el correcto funcionamiento.David: 622837069CP PABLO NERUDA 78 - SAT 1 - CP PABLO NERUDA 78SAT - RUTA 02 - CP PABLO NERUDA 78Aviso - TF0.00 €0.00 €163.50 €MTOGN - Mantenimiento General - VisitaMIGUEL ÁNGEL FERNÁNDEZ GUIJARRO000000000800NaT2022-07-06 10:53:002022-07-06 12:00:002022-07-06 14:00:002022-08-06 11:46:00
119462214156NaNCorrectivoRealizadoLECTURA DIARIA DE CO2EDF-MM-C33-ED-AAMB0-001CALIDAD INTERIOR DEL AIREARTURO MORENO PEÑA2022-07-06LECTURA DIARIA DE CO2MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - MUTUA - CASTELLANA 33EDIFICIO - MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - CASTELLANA 33 - EDIFICIOSolicitudes FMVentilaciónMedia0.00 €0.00 €0.00 €GEN - Genérico - Estudio Calidad del Aire (CAI)000000000145NaT2022-07-06 12:20:00NaTNaT2022-07-06 12:22:00
119463214157NaNCorrectivoRealizado54201 Sum. y sust. de válvula de flotador para llenado de torre de refrigeración.SAT-R01-CPA102-MTOGNMANTENIMIENTO GENERALJUAN VAZQUEZ2022-07-06Se sustituye boya torre de refrigeración centro. Se comprueba su correcto funcionamientoCP ALMANSA, 102 - SAT 1 - ALMANSA 102SAT - RUTA 01 - CP ALMANSA, 102Presupuesto0.00 €0.00 €0.00 €MTOGN - Mantenimiento General - VisitaISRAEL VILLALBA DURÁN000000000100NaT2022-07-06 12:29:002022-10-06 11:00:002022-10-06 12:00:002022-10-06 13:08:00
119464214158NaNCorrectivoRealizadoLECTURA DIARIA DE CONTADORESEDF-MM-C33-JD-CONT-009CONTADORES DE AGUA GENERALARTURO MORENO PEÑA2022-07-06LECTURA DIARIA DE CONTADORESMUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - MUTUA - CASTELLANA 33EDIFICIO - MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - CASTELLANA 33 - JARDÍNSolicitudes FMFontaneríaMedia0.00 €0.00 €0.00 €CONT - Contador - AguaMedición Consumos000000000100NaT2022-07-06 12:37:00NaTNaT2022-07-06 12:37:00
119465214160NaNCorrectivoRealizadoNo llega tensión al ascensor del centro.SAT-R05-AECC-MTOGN-001MANTENIMIENTO GENERALAVELINO GARCIA2022-07-06Se dan indicaciones de manera telefónica, pero es necesario desplazarse al centro ya que nos comunican que el personal de ascensores no ve nada raro en cuadro general de planta-1.\r\nUna vez en el centro observamos que el automático general de montacargas + relé de rearme está caído.\r\nSe rearma y se comprueba correcto funcionamiento.\r\nLlamarán a personal de ascensores para realizar las pruebas pertinentes.ASOCIACIÓN ESPAÑOLA CONTRA EL CANCER (AECC) - SAT 1 - ASOCIACIÓN ESPAÑOLA CONTRA EL CANCER (AECC)SAT - RUTA 05 - ASOCIACIÓN ESPAÑOLA CONTRA EL CANCERAviso - TFEléctrica0.00 €0.00 €0.00 €MTOGN - Mantenimiento General - VisitaJAVIER TERRÉS GÓMEZ000000000230NaT2022-07-06 13:01:002022-07-06 12:30:002022-07-06 14:00:002022-07-06 15:00:00
119466214163NaNCorrectivoRealizadoAcompañamiento junto a CarrierSAT-R09-ALHELI-MTOGNMANTENIMIENTO GENERALJUAN VAZQUEZ2022-07-06Acompañamiento junto con técnicos de control para solucionar averías de control.\n\n- Se detecta condición de motobombas de retorno de acs, la cual se elimina, que hacía parar las bombas si los depósitos bajaban de 53°C por lo que a primera hora con gran demanda podían parar provocando que el agua caliente tardase en llegar, sobre todo en los portales más alejados.\n\n\n- Crean un nuevo gráfico para controlar individualmente las bombas de primario de acs, que estaban funcionando las dos a la vez 24h.viernes 10/06 entre 08:00 y 08:30CP ALHELÍ 3 EDIFICIO RESIDENCIAL ESCALONIA. - SAT 2 - CP ALHELÍ 3 EDIFICIO RESIDENCIAL ESCALONIASAT - RUTA 09 - CP ALHELÍ 3 EDIFICIO RESIDENCIAL ESCALONIAAviso - CM0.00 €0.00 €0.00 €MTOGN - Mantenimiento General - VisitaMtto GeneralARTURO DE LAS HERAS MARCIAL000000000300NaT2022-07-06 13:48:002022-10-06 08:00:002022-10-06 11:00:002022-06-13 11:33:00
119467214164NaNCorrectivoRealizadoSE CAMBIA GOMA DE ENCHUFE EN TAZA CABINA DERECHAEDF-MM-C33-P05-AS-ASEOS-005ASEOS P05ARTURO MORENO PEÑA2022-07-06SE CAMBIA GOMA DE ENCHUFE EN TAZA CABINA DERECHAMUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - SAT 1 - MUTUA - CASTELLANA 33EDIFICIO - MUTUA MADRILEÑA, SOCIEDAD DE SEGUROS A PRIMA FIJA - CASTELLANA 33 - PLANTA 5 - ASEOSCorrectivoFontaneríaMedia0.00 €0.00 €0.00 €GEN - Genérico - Aseo000000000100NaT2022-07-06 14:08:00NaTNaT2022-07-06 14:13:00